2 Replies Latest reply: Apr 14, 2017 5:52 AM by Pankaj Bhalekar RSS

    Qlik sense Expression on Condition (KPI)

    Pankaj Bhalekar

      Hi,

       

      I am unable to write Expression for my condition.

      My condition is as below :

      I have table as :

      Name   Value

      A23
      B30
      C45
      D55
      E15

       

      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