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.