topic Re: Gauge Chart Question in QlikView

Gauge Chart Question

Wed, 20 Apr 2016 08:59:43 GMT

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 — Wed, 20 Apr 2016 12:01:54 GMT

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

Vikas

Mon, 25 Apr 2016 02:08:53 GMT

Hi Vikash,

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

vikasmahajan — Tue, 26 Apr 2016 05:17:44 GMT

what error you are getting ? or do you have PE

Vikas

Tue, 26 Apr 2016 05:21:12 GMT

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