topic Re: Colour Conditioning for perecntages for in chart text in QlikView

Colour Conditioning for perecntages for in chart text

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

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

Re: Colour Conditioning for perecntages for in chart text

ankur_abhishek — Fri, 23 Jun 2017 08:06:59 GMT

Hi Aaron,

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

Thanks

Ankur

Re: Colour Conditioning for perecntages for in chart text

prat1507 — Fri, 23 Jun 2017 08:38:16 GMT

Can you plz share a sample app?

Regards

Pratyush

Re: Colour Conditioning for perecntages for in chart text

Anil_Babu_Samineni — Fri, 23 Jun 2017 08:40:33 GMT

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

Re: Colour Conditioning for perecntages for in chart text

aaronnayan — Fri, 23 Jun 2017 08:41:01 GMT

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

Re: Colour Conditioning for perecntages for in chart text

prat1507 — Fri, 23 Jun 2017 08:42:29 GMT

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

Regards

Pratyush

Re: Colour Conditioning for perecntages for in chart text

aaronnayan — Fri, 23 Jun 2017 08:43:50 GMT

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

HTH

Re: Colour Conditioning for perecntages for in chart text

prat1507 — Fri, 23 Jun 2017 08:44:13 GMT

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

Re: Colour Conditioning for perecntages for in chart text

devarasu07 — Fri, 23 Jun 2017 08:44:15 GMT

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

Re: Colour Conditioning for perecntages for in chart text

aaronnayan — Fri, 23 Jun 2017 08:45:20 GMT

Sorry could you explain more?

Re: Colour Conditioning for perecntages for in chart text

prat1507 — Fri, 23 Jun 2017 09:12:53 GMT

are you using an expression in your variable and do you want that expression to run on your different dimensions, what you can do is declare the variable as

vUT%

Expression (remember not to give '=' sign)

and in the expression of your chart use the variable as $(vUT%).

So remove = from your expression and use

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

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

Green()))

Regards

Pratyush