Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
romain_p
New Contributor

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
Valued Contributor

Re: Change color according to a calculated condition

Hi,

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

clr.png

romain_p
New Contributor

Re: Change color according to a calculated condition

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
New Contributor III

Re: Change color according to a calculated condition

could you upload an example file?

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

Community Browser