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

    Qlik sense Colors with Condition

    Pankaj Bhalekar

      Hi Experts,

       

      I have following table :

        Name   Value

      A23
      B30
      C45
      D55
      E15

       

      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