Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Change background color in pivot table

Dearest members,

Currently I am struggling with the background color of a pivot table where I compare two (or in the future multiple) years, see screenshot of the table below;

PrtScr.png

What I would like to get done is that when the value of 2016 is higher than the value of 2015 to turn it into red and vice versa. I've already tried several options with RowNo() etc. but I cannot get it done Could you guys please help me out??

All input is much appreciated. Thanks!!

Kind regards, Jeffrey

1 Reply
girirajsinh
Creator III
Creator III

try something like following