Qlik sense Expression on Condition (KPI)

[#1]

Hi,

I am unable to write Expression for my condition.

My condition is as below :

I have table as :

Name   Value

A	23
B	30
C	45
D	55
E	15

I want expression like : If value is greater than average value ,then it should be red else green

I am trying like   if(sum(value) > AVG(value) ,Red(),Green())

it is showing all green

and when i tried this : if(sum(value) > 33 ,Red(),Green())   it is giving proper output as C and D red

I want dynamically

Please help

[bhargav_bhat]

Hi Pankaj,

Try the below expression  see if it works

if(sum(value) > avg({1} value) ,Red(),Green())

Regards,

Bhargav

[#3]

Thanks  ,

But i achieved it using - if(avg(value) > avg(Total aggr(avg(value), name)), Red(), Green())

Thanks & Regards,

Pankaj Bhalekar