Create a Dashboard Using QlikView

Then the following window will be opened:




Step 13:Select the Expression: Then the new list box window will be opened; select the expression and click on the "Add" button.




After clicking on the Add button, an edit expression window will be opened; click on the Paste button, the field will pasted onto the edit expression; click on the "OK" button.




Then the following window will be opened; click on the "OK" button.



The following shows the main window of the dashboard:




Step 14: Select a Chart: The next step is selecting a chart, for this process right-click anywhere then seelct:

"Properties" -> "New sheet object" -> "List box"

Then the following window will be opened:




Step 15: The Chart properties General window will be opened; select a chart type and click the "Next" button.




Sep 16: Select a Dimension in Chart type: The next step is select a field and click on the "Next" button.




Step 17: Select a Aggregation and Field: In the Edit Expression Window, select an aggregation and field for calculating the sum.




After clicking on the "OK" button , the following window will be opened; click on the "Finish" button to finish this process.




Step 18: This is the main window that displays the salary of the employee and the name and city of the current EmpId.




Step 19: Go to the Chart property: the next step is to again select a chart type of the sum salary, simply right-click on the Sum (salary) and select the property.




It will then show the chart property of Sum (salary) and go to the "General" tab.




Step 20: Set the Fast Change Option: In this step, we set the fast change option and select the chart type from the Allowed types and click on the "OK" button.




Step 21: Click on Fast Change Option: When we click on the Fast change option in Sum (salary) then it will show various chart types.




Step 22: Show various Charts: After clicking on the fast change option it will show various types of charts, what you select in the Allowed types in the Chart property/




Then, after again clicking it shows a Pie chart as in the following:

Step 23: Select a Statistics box: The next step is to select a statistics box, for this process right-click anywhere then seelct "Properties" -> "New sheet object" -> "Statistics Box", then the following window will be opened:

Then, in the following window we select a field and click on the "OK" button.

Step 24: It will then show the final dashboard.




These are the steps for implementing the dash board in QlikView.

Summary

This is the simplest way to represent the dashboard in a QlikView application. Following these operations we can add multiple dashboards to a QlikView application.