Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Welcome to Qlik Community! Check out our new navigation! FIND OUT MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
aaronnayan
Creator III
Creator III

Colour Conditioning for perecntages for in chart text

Hi Guys

I have an expression

I am trying to color code the text

My value is a percentage

Below keeps the value to green

And it does not change

This is not working:

=IF(vUT%>=0.0 and vUT% <= 0.5, RED(),

IF(vUT%>=0.51 and vUT% <= 0.7, YELLOW(),

Green()))

1 Solution

Accepted Solutions
devarasu07
Master II
Master II

=IF((sum(Sales)/sum(Total Sales))>=0.0 and (sum(Sales)/sum(Total Sales)) <= 0.5, RED(),

IF((sum(Sales)/sum(Total Sales))>=0.51 and (sum(Sales)/sum(Total Sales)) <= 0.7, YELLOW(),

Green()))

View solution in original post

10 Replies
ankur_abhishek
Contributor III
Contributor III

Hi Aaron,


Could please provide the sample value of vUT% field so that i can provide you the solution

Thanks

Ankur 

prat1507
Specialist
Specialist

Hi

Can you plz share a sample app?

Regards

Pratyush

Anil_Babu_Samineni

Can you use Square Brackets ([]) around your expression. What does the expression for vUT% and how values are looks like?

=IF([vUT%] >= 0.0 and [vUT%] <= 0.5, RED(),

IF([vUT%]>=0.51 and [vUT%] <= 0.7, YELLOW(),

Green()))

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)
aaronnayan
Creator III
Creator III
Author

Im sorry pratyush i cannot,

the value stays green and does not change to red or yellow depending on what it is

i.e: If the percentage is lower than 50% it should be red

higher than 70% it should be green

prat1507
Specialist
Specialist

Hi

Can you just give me an idea as to how you've declared the variable?

Regards

Pratyush

aaronnayan
Creator III
Creator III
Author

vUT%= (avg(Aggr(sum(JO_)/(TGT),_Vehicle)))

HTH

prat1507
Specialist
Specialist

It is giving green coz it is not satisfying any of the conditions above, try to use the variable in text. Capture its value and then try to check that in your condition.


Regards
Pratyush

devarasu07
Master II
Master II

=IF((sum(Sales)/sum(Total Sales))>=0.0 and (sum(Sales)/sum(Total Sales)) <= 0.5, RED(),

IF((sum(Sales)/sum(Total Sales))>=0.51 and (sum(Sales)/sum(Total Sales)) <= 0.7, YELLOW(),

Green()))

aaronnayan
Creator III
Creator III
Author

Sorry could you explain more?