Gauge Chart Question

[#1]

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.

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

Hope you guys can help me out.

Thanks,

Romer

[vikasmahajan]

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

Vikas

[#3]

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

[#5]

Hi vikasmahajan‌

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