Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
romain_p
Contributor II
Contributor II

Change color according to a calculated condition

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.

3 Replies
el_aprendiz111
Specialist
Specialist

Hi,

if(Product='Product 4' and Year=2017,RGB(255,0,0),rgb(0,0,0))

clr.png

romain_p
Contributor II
Contributor II
Author

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...

shuck1985
Contributor III
Contributor III

could you upload an example file?

should be doable just fine but I would like to see your expressions/aggregations