Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Easy (but reasonably capable) KPI box in QlikView using (simply) a straight-table
A basic example of a KPI box using a straight table is shown here. (Example is for illustration purpose showing This Year's KPI and percent change from previous year. It can be further enhanced or changed as required). The purpose of this blog is to show how something like this can be easily and quickly configured using out-of-the box properties of a straight table.
Benefits:
Simple to configure; quick to replicate--just copy and paste and change expressions; and easy to customize the presentation. Only one object per KPI box (i.e. 1 straight table)--so very manageable. Example shown here is quite basic...to further customize, such as adding images (such as up or down arrows)-- compute within expression and represent as image.
How to:
Here there are 4 simple expressions:
The raised appearance is obtained by border settings of the chart in Layout as shown below:
To change gridline properties use Style: