topic Gauge Chart Color coding in QlikView

Gauge Chart Color coding

mhmmd_srf — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

I have a gauge chart where I am showing Actual Sales - Planned Sales.

And my Color coding is :

if Deviation <0, Red,

if Deviation = 0, Yellow,

if Deviation >0, Green.

But if deviation >0, then also the pointer is not going to Green area.

I am attaching my app. Could you please check and help me.

Thanks,

Sarif

Re: Gauge Chart Color coding

sunny_talwar — Mon, 03 Apr 2017 10:55:22 GMT

Your min and max are way too big

See what happen when I lower the number

Re: Gauge Chart Color coding

Anonymous — Mon, 03 Apr 2017 11:32:41 GMT

Hi Sarif,

To display the Guage segments, you have to specify the minimum and maximum values with valid ones.

I have modified your QVW and attached below. Please find it and see the min and max values.

Note: 1) I have assumed sum(ContarctSales)>=0 and sum(PlannedSales)>=0 in your case. If it changes you have to change the condition for min and max values.

2) As Yellow = 0, it displays as the single line where red (<=0) and green(>=0) matches.