Creation Of Mini Chart In QlikView Application

Introduction

A Mini Chart is the way to represent a bar chart and trend chart in a cell of metrics. It is very useful because in one column the Mini Chart shows the current value and another cell shows the historical trends of that value.

Creation of Mini Chart in QlikView Application.

Use the following procedure to create a sample of a Mini Chart.

Step 1: Open the QlikView application

In the first step you need to open the QlikView application then go to File-> New then this window will be opened.

After clicking New option

Step 2: Open Edit Script

The second step is open the edit script window from:
File-> Edit Script.

window of edit script

  • Then this window will be opened.

    window
Step 3: Click on the table files.

table file

In this step we open our Excel file and click on the Open button.

local file

Step 4: File wizard window

Then this window will be opened. Now here you can see your Excel file will be opened that you import in the table files and click on the Finish button.

file wizard

Step 5: Code of edit script

Now, in the edit script the Excel file upload was successful and reload it.

reload

Step 6: Save file

The next step is we need to save our QlikView file.

save file

Step 7: Sheet property window

The sheet property window will be opened. In this window you add fields that you want to display as a table and click on the OK button.

sheet

Then you will see this window.

main

Step 8: Select a chart

Right-click anywhere in the main window and select chart.

chart

Step 9: Next the General window will be opened and select chart and click on the Next button.

general

Step 10: Add Dimension

The next step is to add fields and click on the Next button.

dimension

Step 11: Edit expression window

When you click on the next button then the edit expression window will be opened. Here you define the function then click on the OK button.

Suppose I want to define a sum of empids then I use empid.

exp

Step 12: Select Mini Chart

When we click on the OK button then the expression window will be opened. Here we select Mini Chart from the Representation tab and click on the Mini Chart settings.

mini chart

Step 13: Mini Chart settings

Here we can set the Mini Chart settings according to our own choice and click on the OK button.

settings

Then click on the Finish button.

exp2

Now here you can see the sum of empids because in the edit expression I used the sum function.

final1

Step 14: Add another Mini Chart

If you want to add another Mini Chart then go to the properties of the Mini Chart.

property

Step 15: Now click on the Add button, then the Edit Expression window opens. Then you define another function and click on the OK button.

add

Suppose here I want to define the sum of salaries then I use salary.

exp3

Then select Mini Chart and click on the Mini Chart settings button.

exp4

Step 16: Mini Chart settings

Here we can set Mini Chart settings according to own choice and click on the OK button.

settings1

Then click on the OK button.

exp5

Now here you can see the sum of the salaries because in the edit expression I used the sum function.

final2

Summary

This article described how to create a Mini Chart in a QlikView application.