In today’s post, I want to share a simple / not incredibly useful app that I use very often as a QlikView trainer. In my courses, I like to guide most of the exercises step by step and give tips and tricks as we encounter new functions or objects. However, some exercises have better results when working alone, especially when working with charts. For example, when I present themes, containers, tabs and auto-minimize I like to give the students a few minutes to decide the way their applications would look like.

In the beginning, I used to tell them the approximate time that we were going to spend on the exercise and the expected finish hour. As you can imagine, nobody kept an eye on the clock and we always had delays, so one day I created this application. [Download]

12.2The idea is to store the expected time for the exercise in a variable using an input box and after clicking START, the gauge in the right would represent the remaining time using the function now(). When the clock hits the “Red Zone” (another variable), the gauge turns red. Continue reading


Just Qlik it: Double Gauge

‘Just Qlik it’ is a new section of our blog that focuses on sharing useful components… that kind of objects that are not incredibly complex, but are easy on the eye and convenient to have around.

On our first delivery, I’d like to share a double gauge that gets along pretty well with comparisons between ratios (for example, net and gross margins).


You can easily copy, paste and configure this component by modifying the colors and formulas in the Presentation tab. Just remember that there are two independent gauges and that you should include your formula in the Lower Bound of the second segment.

You might also want to change the Min and Max values allowed. If your numbers are usually between 0% and 30% there’s no need for a gauge that goes all the way to 100%.


[ Download File ]

I often use this kind of representation to highlight the main KPIs of the tab and reinforce them with a detailed table in the lower part of the screen. In the downloadable file, most of the objects are dummies created only to Continue reading