how to handle a gauge that has three segments / three colors?

[Anonymous]

hello, I would like to write a condition on a gauge that will move the needle according to the value of the segment.

for example if the value is 50 the percentage is displayed in red if it is 80 is displayed in yellow and if it is 90 it is displayed in yellow.

And also how do you represent an interval in qlikview?

Thank,for your responses.

[Anil_Babu_Samineni]

Will you able to share sample?

[Anonymous]

=If(num(avg(#Satisfaction_client)/100,'##.00%') < vCibleSatisfactionClient, RGB(255,127,0), if(num(avg(#Satisfaction_client)/100,'##.00%') > vCibleSatisfactionClient, RGB(238,238,0), If(num(avg(#Satisfaction_client)/100,'##.00%')> 88, RGB(238,238,0))))

I need a condition that will work for all three.

this only takes on two

[sasiparupudi1 · Accepted solution]

what is the value in the vCibeSatisfactionClient?..

May be try

If(num(avg(#Satisfaction_client)/100,'##.00%') < vCibleSatisfactionClient, RGB(255,127,0), if(num(avg(#Satisfaction_client)/100,'##.00%') > vCibleSatisfactionClient and num(avg(#Satisfaction_client)/100<=88,'##.00%') , RGB(238,238,0), If(num(avg(#Satisfaction_client)/100,'##.00%')> 88, RGB(238,238,0))))

[Anonymous]

the third condition does not give

If(num(avg(#Satisfaction_client)/100,'##.00%')> 88, RGB(238,238,0))))

[sudhirpkuwar]

Hi,

Check this

[Anil_Babu_Samineni]

That is where we need mockup