Qlik Community

QlikView Documents

QlikView documentation and resources.

Announcements
Support Case Portal has moved to Qlik Community! Read the FAQs to start exploring Support resources.

A sneaky use of QlikView gauges - Doughnut gauges

DavidFoster1
Specialist
Specialist

A sneaky use of QlikView gauges - Doughnut gauges

Here is a quick entry on how to create a doughnut gauge. These gauges provide an effective way of representing a percentile measure like a KPI. The gauge has the advantage over a Pie Chart of only requiring only one expression and can be formatted to produce a much cleaner looking chart.

donut_gauge.png

Step 1: Write your expression. You dont need to use a percentage you can use a total value.

Step 2: Add a gauge chart to your document

Step 3: Configure the gauge

     GENERAL: Gauge

     DIMENSIONS: No Dimensions

     EXPRESSIONS: =1 (this forces the gauge to show the full circle)

     STYLE: Choose the simple circular gauge.

     PRESENTATION:

          Min = 0

          Max = 1

          Indicator.Mode = Fill to Value

          Show Scale = untick

          Autowidth Segments = untick

          Cylinder Thickness = 50

          Angle Span = 360

          Center Angle = 0

          Hide Segment Boundaries = tick

          Hide Gauge Outlines = tick

          Segment 2.LowerBound = Expression from step 1

          Segment 2.Colour = Black

          Text in Chart = Expression from step 1

That's it. You can finesse to your hearts content. If you prefer to not use a percentage then the expression and the max need to be the total of the whole measures and the segment 2 lower bound would need to be the subset's measure value (really useful for showing things like data quality scores, order completeness, etc)

Tags (3)
Comments
c_gilbert
Creator II
Creator II

I agree it's best avoided, but it seems people are layering to create workarounds for functions not yet possible in QlikView. For example, we use the usual speed gauge charts, but the users wanted 2 needles to be able to compare previous and current month on the same gauge, so we had to layer to get the desired outcome.

ThornOfCrowns
Specialist II
Specialist II

I like those a lot!

0 Likes
ThornOfCrowns
Specialist II
Specialist II

Yes, layering a common way to get around some of the "Qlikview-isms" and it helps to give a nice look and feel a la the flat UI that's in vogue at the moment.

Is it true that there's no layers on .next?

0 Likes
DavidFoster1
Specialist
Specialist

I had a go in Raphael.js. Now all I need is a spare century to convert it into a QV extension 🙂

multi-donut.jpg

datanibbler
Champion
Champion

Oh my - I'm glad that my management will never look in here. They'd have me change it all, taking up a lot of time without creating any "added value", to make it look "sexy" as they say, probably making it less usable along the way 😉

The doughnut chart looks great and very much usable and intuitive. The thing is only that I need to focus a bit on that "added value" so we ´have arguments for keeping and indeed promoting QlikView beyond this branch, so I can't spend too much time on visuals. Also, you have to cater for whoever is going to use your apps and their - eh, capacity...

mvanlutterveld
Partner
Partner

Great and inspiring posts here!

The example of Rohan is something I used also. It worked great until I tested my dashboard in webview. The circular textbox won't work in webview (they are displayed as a square). I've solved this by replacing the textbox with a second gauge object with a 360 span.

Unfortunately the gauge can't be filled for a 100% (90% is the max) so to remove the white middle of the inner gauges you have to use a small text box (layer number 3.....).

Gauges.PNG.png

Not applicable

Hey Michiel,

I tried using the another chart with 360 span, but when I open the webview in the desktop itself, the circular corners are turned to rectangular. Is there anything I am misssing? See the attached screenshots.

mvanlutterveld
Partner
Partner

Hi Angad,

The Webview can’t present Text objects with a 360 span. These are always presented rectangular. When you use a second gauge chart instead of a text object, you’ll get what you want.

Not applicable

Thanks michiel. I did not use text object. But the above image attached was of empty gauge chart with borders displayed. Such case does not work in Webview. I actually created a gauge chart with no borders then it worked. May be I misunderstood your earlier comment.

Thanks for all the help.

0 Likes
mvanlutterveld
Partner
Partner

Hi Angdad,

Great you solved it!

0 Likes
Version history
Revision #:
1 of 1
Last update:
‎2013-09-11 12:15 PM
Updated by: