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:

After clicking New option


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

"File" -> "Edit Script"

Then the following window will be opened:

Window of edit script


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

Click on table file


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

file wizard


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

Enable Transformation


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

file wizard options


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

file wizard script


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

code of edit script


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

after reloading


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

Save the file


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

/sheet property


 Then the following window will be opened:

main window


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:

right click


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

list box


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.

edit expression


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

Ok button

The following shows the main window of the dashboard:

lastwindow


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:

select a chart


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

General window


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

Dimension window


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

Expression Window


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

Exp window


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

Main 2 window


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.

Salary property


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

Sum salary


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.

charts


 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.

On click fast change


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/

show gauge chart


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

show pie chart


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:

selecting a Statistics box


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

Stat box


Step 24:
It will then show the final dashboard.

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.

Up Next
    Ebook Download
    View all
    Learn
    View all