Quote

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).

9.1

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

9.2

[ 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 provide inspiration and a little bit of context on where and how you could use this specific chart.

9.3By the way, the data model is randomly generated using the CTRL + Q + Q shortcut shared by Patrick Tehubijuluw from QlikShow. (I don’t know how I could live without this for so many years.)

As I said before, the idea behind the ‘Just Qlik it’ series is to share simple objects that anyone can use in their applications. They may not be absurdly complex or demand hours of analysis to understand, but I hope you find them useful for your apps.

Any comments? Please share in the section below!

Advertisements

3 thoughts on “Just Qlik it: Double Gauge

  1. C. Lisboa says:

    The problem with you gauge are the negative values.
    If the expression evaluates to a negative value the gauge doesn’t give any visual indication of the value itself.

    • Great observation! I think that you can add some extra stuff to handle that problem. First, you may want to change the ‘Min’ setting for the gauge to a negative number. After that, we could add a Reference Line (Presentation tab) to highlight where the positive numbers begin, so our expression would be ‘0’.

      We could go further by applying formulas to the colors of the segments and reference lines. For example, if your margin is lower than 0, set the color of the gauge to red, if not, keep the original color. Here’s an example:

      https://www.dropbox.com/s/pok2twifk3988ys/Double%20Gauge%20V2.qvw?dl=0

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s