A dashboard or cockpit should clearly communicate key information to users. It should be kept simple and therefore and effective design is crucial. Besides showing the current situation, it should also show comparisons and trends.
Implementing simple reusable KPI boxes is one way to show different KPI's on a dashboard or cockpit. These would look like:
We can clearly see the current situation, with some additional informations about previous year or comparison to the budget. All this can done by using textboxes and some codes.
Within the QlikView application put the code below in the script editor:
In the Fonts register, for color I put this expression for calculating the color: $(PerformanceColor($(=sum(Sales)), $(=sum(Budget))))
And the result shows me the difference in percent and because my Sales are higher then my budget, the colors appear in green. Arranging them all, I have then a KPI box, which I also can reuse to compare with previous year or for other KPIs.