Qlik Community

Ask a Question

Brasil

Announcements
QlikWorld starts MONDAY! last chance to register is now ! REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
caio_caminoski
Creator
Creator

Creating a Good Looking Gauge Chart in Qlikview

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:

Gauge Chart.PNG

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

Gauge 1.PNG

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

1.png

In the Presentation tab we will do the big changes.

Presentation 1.png

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.

Color.PNG

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.


Text.png

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

Moving.png

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

See you around QlikCommunity!

9 Replies
MK_QSL
MVP
MVP

Not applicable

Very nice!

Thanks for sharing.

caio_caminoski
Creator
Creator
Author

Manish, I updated the post based in your examples!

Thanks a lot!

jonas_rezende
Specialist
Specialist

Very well.

Thanks a lot.

daniel_vale
Creator
Creator

cool idea

congratulations!


Thanks a lot.

Not applicable

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
Creator
Creator
Author

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
Master
Master

Thanks a lot for this great work,

thanks for sharing

Damian_Waldron
Employee
Employee

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.