Create a Dashboard Using QlikView

Introduction

The Dashboard is very important part of the QlikView because it shows the entire information in a graphical manner using charts and a tabular format.

Step 1: Open the QlikView application, then go to:

 "File" -> "New"

Then the following window will be opened:




Step 2: Now open the window of Edit Script as in the following:

"File" -> "Edit Script"

Then the following window will be opened:




Step 3: The next step is to simply click on 'Table Files' and open our Excel file as in the following:




Step 4: After opening the Excel file, the following window will be opened; click on the "Next" button-.




Step 5: After clicking on the "Next" button the following window will be opened; click on the "Next" button.




Step 6: After clicking on the "Next" button, the File Wizard Options window will be opened; simply click on the "Next" button.




Step 7: After clicking on the "Next" button, the File Wizard Edit Script window will be opened; simply click on the "Finish" button.

Step 8: Code for the Edit Script: the following window shows the code and reloads it.




Step 9: After reloading the edit script, click on the "OK" button.




Step 10: Save the QlikView file:  The next step is save the QlikView file and click on the "Save" button.




Step 11: After saving the QlikView file, the sheet property window will be opened and select a field and click on the "OK" button.




 Then the following window will be opened:




Step 12: Select a List Box: In the main window, right-click anywhere then select:

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

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.