Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Johan3
Contributor
Contributor

Conditional color in table

Hi,

I have a table in Qlik sense where I want the colors of the cells to be on a scale from red to yellow to green depending on the value of the cell in relation to each other, so that the lowest (negative) value is red and then closer to yellow the closer to 0 it gets and then on a scale from yellow to green the higher the value is. The picture is from Excel and the way I want it in my Qlik sense app.

I used the ColorMix2 function and managed to get the colors on a scale from red to yellow to green, but only compared to the rest of the row. I want it to be in relation to all cells (rows and columns combined) in the table. 

Thanks! // Johan

triangle.PNG

Labels (1)
0 Replies