3 Replies Latest reply: Mar 21, 2017 8:06 AM by Pankaj Bhalekar RSS

    Qlik sense Colors with Condition

      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