topic Re: In chart text colour conditioning in QlikView

In chart text colour conditioning

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

Hi Guys

I have an expression its not coming out right

Metrics

0-50= RED

51-70= YELLOW

70-90=GREEN

90+= BLUE

This is whats coming out currently

Can anyone help with this

If you could write the correct expression it will help significantly

Re: In chart text colour conditioning

Frank_Hartmann — Thu, 06 Jul 2017 12:59:51 GMT

can you upload a small sample?

Re: In chart text colour conditioning

dberkesacn — Thu, 06 Jul 2017 13:02:10 GMT

When you making the avg you have to use agg function.

if(aggr(sum(Value),Dim)/aggr(Count(Value),Dim)<10,red(),Green())

Re: In chart text colour conditioning

aaronnayan — Thu, 06 Jul 2017 13:06:09 GMT

This 51 should be yellow but it is not

Re: In chart text colour conditioning

Anil_Babu_Samineni — Thu, 06 Jul 2017 13:06:50 GMT

Can you try this?

If(Avg(Date) >= 0 and Avg(Date) <= 50, Red(), If(Avg(Date) >= 51 and Avg(Date) <= 70, Yellow(), If(Avg(Date) >= 71 and Avg(Date) <= 90, Green(), Blue())))

But, I doubt how Avg(Date) given the values to you?