Creating a Good Looking Gauge Chart in Qlikview

[caio_caminoski]

Hello Guys!

I am always seeking for good ideas trough the community and I never get disappointed. That is why I decided to share this format of gauge chart with you. So far, there is a quite big gap between formatting objects in qlikview and qliksense. I see that this is about to be changed. Meanwhile, I was trying to improve the design of my gauge charts and, based on other ideas, I came up with the following one:

To achive that you will have to create a gauge chart (not a pie one), select the first 'look' in the Style property tab.

Go to your 'Expressions' tab and set '1' as Definition

In the Presentation tab we will do the big changes.

Note we will have two segments. The Lower Bound of our second Segment is where we should insert our expression. The color should be a light gray.

For the first segment we could add a conditional color to make it more intresting.

Next step is adding a 'Text in Chart' with our expression. Note that I am using a 'num' function to format it as percentage. I changed the size and color of my font to make it bigger and less dark and centralized it as well.

Now just center your text in the middle of your chart holding Ctrl + Shift and moving the text red line box.

That is it! I hope I could have helped someone!

See you around QlikCommunity!

[MK_QSL]

Thanks for sharing....

Few more examples on Gauge Chart

Dislike gauge charts? You may want to give them a second chance

QlikView Design - Gauge Chart Tip and Trick

Dual gauge realistic examples

[#3]

Very nice!

Thanks for sharing.

[caio_caminoski]

Manish, I updated the post based in your examples!

Thanks a lot!

[jonas_rezende]

Very well.

Thanks a lot.

[daniel_vale]

cool idea

congratulations!

Thanks a lot.

[#7]

Hi All,

First of all thanks for sharing it.

I have tried as shown above by caio_caminoskion Jun 9, 2015 1:41 PM.

But i'm getting chart as shown below only. I'm not getting full circle in ash color in back ground to sky blue color which represents 100%. please help me in this.

Note: Here in place of value I'm using sum(1value) / sum(2value) because i will get actual value if i divide the two values..

[caio_caminoski]

Hi Uday, how are you doing?

Have you checked if the colour for the second segment is gray? it is suppose to have segment 1 with the colour you intend to use for filling up the chart and the segment 2 is suppose to be the 'background'.

If you do have it, could you share a sample qvw?

Regards,

Caio

[beck_bakytbek]

Thanks a lot for this great work,

thanks for sharing

[Anonymous]

Thanks for sharing. I suggest also un-checking popup labels on the presentation tab. If this is checked then when the user hovers over the guage '1' is displayed as a popup message.