Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Is it possible?
Thanks for reading, and sorry for my bad English... French native here.
Hi,
if(Product='Product 4' and Year=2017,RGB(255,0,0),rgb(0,0,0))
Thanks Fer fer, it is a beginning. I'd like to do it not only for 2016/2017 and product 4 but also to each product for each year.
I'd like to automatically change the color considering the previous year value. I hope I am clear enough...
could you upload an example file?
should be doable just fine but I would like to see your expressions/aggregations