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