1 Reply Latest reply: Mar 19, 2015 7:12 PM by Nico Manro Oberholzer RSS

    KPI colour expression between measures

    Imtiaz Ullah

      Hi guys,

       

      I have 2 measures in the new QS KPI visualization and am trying to set the colour of the values based on an expression.

       

      One measure is a calculation for current year and the other is for previous year. (I can supply the code if needed when I get home) .

       

      Basically I am trying to set the colour of measure 1 (current year)  to be either red or green depending on the Value of the previous year. Green is higher,  red if lower.

       

      My measures are working fine,  but I just can't figure out how to set the expression for measure 1.

       

      Does that make sense?

      I will post code later if need be.

       

      Thanks

      Immy