Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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))))
Will you able to share sample?
=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
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))))
the third condition does not give
If(num(avg(#Satisfaction_client)/100,'##.00%')> 88, RGB(238,238,0))))
Hi,
Check this
That is where we need mockup