Qlik sense Colors with Condition

[#1]

Hi Experts,

I have following table :

​  Name   Value

A	23
B	30
C	45
D	55
E	15

I want value to be colored based on Condition .

My condition is if value is greater than avg(value) ,it should be red else Green.

I have manually used average value in following expression : if ((value) > 30 ,Red(),Green())    ---- output : 45 and 55 are red others are green

I also tried with if ((value) > Avg(value) ,Red(),Green())   ---It is giving all values as Green color .

I want to calculate expression dynamically (avg value),

Please help

Thanks & Regards,

Pankaj Bhalekar

[sarvesh]

Try like this:

If(Sum(Sales)>30,Green(),If(Sum(Sales)<=30,Red()))

[Patrik_Lundblad]

Hi Pankaj,

Try

if(avg(Value) > avg(Total aggr(avg(Value), Name)), Red(), Green())

Cheers,

Patrik.

[#4]

Thanks Pratik ,it works for me

Cheers