Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
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
Highlighted
Esteemed Contributor

Re: Gauge Chart Question

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

Vikas

Highlighted
Not applicable

Re: Gauge Chart Question

Hi Vikash,

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

Highlighted
Esteemed Contributor

Re: Gauge Chart Question

what error you are getting ? or do you have PE

Vikas

Highlighted
Not applicable

Re: Gauge Chart Question

Hi vikasmahajan

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