Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Gauge Chart Question

Hi Experts,

I'm new in Qlikview and im trying to figure out the gauge chart.

What i wanted is to have 3 segments,

1st segment - 0 to forecast of countries (Red)

2nd segment - forecast of countries to budget  (Yellow)

3rd segment - Budget of countries to budget of countries+12% (Green)

My segment set up are
Segment 1 - "0"

Segment 2 - "=sum([revenue forecast])"

Segment 3 - "=sum(Budget)"

My expression is - "sum(Revenue)"

But my problem is if the forecast exceed that budget the 1st and 2nd segment turns into red. below is the example

Australia - since there Forecast is below the budget then it shows the correct gauge chart.

Ausie.jpg

For china since there forecast exceeds the budget most of it turns into red. how can i fix this issue?

malaya.jpg

Hope you guys can help me out.

Thanks,

Romer

4 Replies
vikasmahajan

I think you need to define in segments please find attached collections for Gauges may help you.

Vikas

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.
Not applicable
Author

Hi Vikash,

Thank you very much for the demo document. Unfortunately I am unable to open the file.

vikasmahajan

what error you are getting ? or do you have PE

Vikas

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.
Not applicable
Author

Hi vikasmahajan

Yes i have a PE. I think my segment setup lower bound is wrong for Segment 1 and 2.