3 Replies Latest reply: Sep 5, 2017 7:57 AM by Beatrice Sell RSS

    Change color according to a calculated condition

    Romain Poudevigne

      Hello Qlikers.

       

      I am currently looking for something new (for me) in Qlik. I'd like to compare two values of a dimension. I guess it will we clearer with an example. So...

       

      Here you can see MS for 5 products from 2012 to 2017.

       

      As you can see, the Product 4 Market share dicrease significativley from 2016 to 2017. I'd like to change the color of the 2017's font from RGB(0,0,0) to GRB(255,0,0) in this case.

       

      To sum up, I'd like to change the font color to red if the value of a product growth from a year to another and to green if it increase since the prevous year?

      Example.png

       

       

      Is it possible?

       

      Thanks for reading, and sorry for my bad English... French native here.