Qlik Community

Ask a Question

QlikView Documents

QlikView documentation and resources.

Announcements
Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources: READ DETAILS

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
sruhlandwf
Contributor
Contributor

Charlotte Gilbert  Can you explain how you created this tiered gauge please?

Can't seem to find any details elsewhere.

thanks.

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