Qlik Community

Ask a Question

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
Welcome to our newly redesigned Qlik Community! Read our blog to learn about all the new updates: READ BLOG and REPORTED ISSUES
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Specialist
Specialist

Hi,

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

clr.png

Contributor II
Contributor II

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

Contributor III
Contributor III

could you upload an example file?

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