Qlik Community

QlikView Documents

QlikView documentation and resources.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW

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
DavidFoster1
Specialist
Specialist

I now prefer to actually have a simple circle image for the background of the central textbox.

mithilesh17
Partner
Partner

Great visualization idea. It works awesome on my Dashboard.

Thanks!

Not applicable

my style of work!    gauge chart with two segment
segment 1 =  grey   360 degree
segment 2 = green   ( according to value)

round.jpg

0 Likes
chetnareth_kim
Enthusiast III
Enthusiast III

Really nice !

0 Likes
Not applicable

Hi!

This was generally very helpful, thank you very much!

However... I am unable to place the text in the middle of the gauge Chart - am I missing a Checkbox somewhere? If I try to position it by siply adding space in front, the text disappears. It seams to be outside of a predefined "box" of some sort. Any help would be awesome! Here you have a Screenshot of what my gauge Chart Looks like right now.

Thanks!!

0 Likes
Not applicable

This was very helpful, thank you! However, I think that it is missing an Explanation on how to place the "Text in Chart" into the middle of the Gauge Chart.

Best Regards!

0 Likes
mvanlutterveld
Partner
Partner

Hi Romana,

Make sure that the gauge chart is active (by clicking on the chart). Press Control + Shift and move the ‘Text in Chart’ box to your desired place in the chart.

Cheers,

Michiel

0 Likes
cristian_av
Creator III
Creator III

Did you try with shift+Control Click?

0 Likes
arjinram
Contributor III
Contributor III

Hi,

Can you please guide me to create 3segments /layers like you did for Current month, Past month, Future month.

Regards,

Arjin.

0 Likes
DavidFoster1
Specialist
Specialist

There is no clever way of doing that. Just make sure your top two layers have transparent backgrounds and then you need to do the positioning using CTRL+Cursor to get them lined up perfectly.

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