In this two part lesson, we are going to build the above dashboard using QLIK Sense. If you don’t already have QLIK Sense, you can download a free trial here: Download
You can download the data set I am working with here: WO
Create new app
Once you have QLIK Sense up and running, click Create new app
Name you new app. I am calling mine DASH
Click Open App
Next click Add data
Now select Excel files – I created my real dashboard using the SQL connector, however it is easier to load the Excel files. So I am using Excel in this lesson. I will show how to load SQL into QLIK in another lesson.
Navigate to the folder you saved the downloaded files to and select WO.xlsx
Note – you can uncheck columns you do not want to use from your data, but I have already removed all unwanted columns for this exercise.
click Load data and finish on the bottom
Once data loads, click Edit the sheet
Now we have a blank sheet to work with
Build the Dashboard
Click on Bar chart and drag it into the upper right corner
You will now be asked for a Dimension and a Measure. If you are not familiar with these terms in data, a dimension is like a category while a measure is something you can add, count, etc.
For Dimension, we will select RequestedOn > Month
For Measure, select WorkOrderKey
Now select Count
Now resize your bar chart by dragging it by the corner.
Next, drag a KPI over from the options in the left column. Place it to the right of your Bar Chart
As a measure, select Scheduled > SUM
Now select Filter pane from the left column and place it next to your KPI. For dimension, select FacilityCode
Now, let’s drag over a Line Chart. Place it below your bar chart. Set Dimension to RequestedON> Date. Set your measure to WorkOrderKey> Count
Now, let’s add a Pie Chart to the right of our line chart. Set Dimension to DepartmentCode and Measure to WorkOrderKey > Count
Now lets clean it up. Click in the upper right corners of your charts that say Click to add title. Give your charts some titles.
Once you have done that, click the Done button in the upper right corner.
Now play with your new dashboard.
In the next lesson, I will show how to add more versatility to your dashboard through used of formulas and Set Analysis.