‘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%.
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