Qlik Community

Qlik Brasil

Group community for Brazil users. discussion only in Portuguese.

Highlighted
caio_caminoski
Contributor

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

Re: Creating a Good Looking Gauge Chart in Qlikview

Not applicable

Re: Creating a Good Looking Gauge Chart in Qlikview

Very nice!

Thanks for sharing.

caio_caminoski
Contributor

Re: Creating a Good Looking Gauge Chart in Qlikview

Manish, I updated the post based in your examples!

Thanks a lot!

jonas_rezende
Valued Contributor

Re: Creating a Good Looking Gauge Chart in Qlikview

Very well.

Thanks a lot.

daniel_vale
Contributor

Re: Creating a Good Looking Gauge Chart in Qlikview

cool idea

congratulations!


Thanks a lot.

Not applicable

Re: Creating a Good Looking Gauge Chart in Qlikview

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
Contributor

Re: Creating a Good Looking Gauge Chart in Qlikview

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

beck110979
Valued Contributor III

Re: Creating a Good Looking Gauge Chart in Qlikview

Thanks a lot for this great work,

thanks for sharing

Employee
Employee

Re: Creating a Good Looking Gauge Chart in Qlikview

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.