topic Re: Qlik sense Colors with Condition in App Development

Qlik sense Colors with Condition

Sat, 16 Nov 2024 09:58:42 GMT

Hi Experts,

I have following table :

Name Value

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 — Tue, 21 Mar 2017 10:09:25 GMT

Try like this:

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

Patrik_Lundblad — Tue, 21 Mar 2017 11:10:22 GMT

Hi Pankaj,

Try

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

Cheers,

Patrik.

Tue, 21 Mar 2017 12:06:15 GMT

Thanks Pratik ,it works for me

Cheers