Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor II
Contributor II

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

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.

13.PNG

1 Solution

Accepted Solutions
Highlighted
Master III
Master III

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))))

View solution in original post

6 Replies
Highlighted

Will you able to share sample?

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Highlighted
Contributor II
Contributor II

=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

Highlighted
Master III
Master III

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))))

View solution in original post

Highlighted
Contributor II
Contributor II

the third condition does not give

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

Highlighted
Partner
Partner

Hi,

Check this

Highlighted

That is where we need mockup

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)