topic Change background color in pivot table in App Development https://community.qlik.com/t5/App-Development/Change-background-color-in-pivot-table/m-p/1218232#M23591 <HTML><HEAD></HEAD><BODY><P>Dearest members,</P><P></P><P>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;</P><P><IMG alt="PrtScr.png" class="jive-image image-1" height="142" src="https://community.qlik.com/legacyfs/online/150517_PrtScr.png" style="height: 142px; width: 1222.78px;" width="1222" /></P><P></P><P>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 <IMG src="https://community.qlik.com/legacyfs/online/emoticons/sad.png" /> Could you guys please help me out??</P><P></P><P>All input is much appreciated. Thanks!!</P><P></P><P>Kind regards, Jeffrey</P></BODY></HTML> Mon, 23 Jan 2017 17:03:54 GMT Anonymous 2017-01-23T17:03:54Z Change background color in pivot table https://community.qlik.com/t5/App-Development/Change-background-color-in-pivot-table/m-p/1218232#M23591 <HTML><HEAD></HEAD><BODY><P>Dearest members,</P><P></P><P>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;</P><P><IMG alt="PrtScr.png" class="jive-image image-1" height="142" src="https://community.qlik.com/legacyfs/online/150517_PrtScr.png" style="height: 142px; width: 1222.78px;" width="1222" /></P><P></P><P>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 <IMG src="https://community.qlik.com/legacyfs/online/emoticons/sad.png" /> Could you guys please help me out??</P><P></P><P>All input is much appreciated. Thanks!!</P><P></P><P>Kind regards, Jeffrey</P></BODY></HTML> Mon, 23 Jan 2017 17:03:54 GMT https://community.qlik.com/t5/App-Development/Change-background-color-in-pivot-table/m-p/1218232#M23591 Anonymous 2017-01-23T17:03:54Z Re: Change background color in pivot table https://community.qlik.com/t5/App-Development/Change-background-color-in-pivot-table/m-p/1218233#M23592 <HTML><HEAD></HEAD><BODY><P>try something like following</P><P><IMG class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/150536_pastedImage_0.png" style="max-height: 900px; max-width: 1200px;" /><IMG class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/150537_pastedImage_1.png" style="max-height: 900px; max-width: 1200px;" /><IMG class="jive-image image-3" src="https://community.qlik.com/legacyfs/online/150538_pastedImage_2.png" style="max-height: 900px; max-width: 1200px;" /></P><P><SPAN style="color: #0066cc; text-decoration: underline;"> </SPAN></P></BODY></HTML> Mon, 23 Jan 2017 18:00:40 GMT https://community.qlik.com/t5/App-Development/Change-background-color-in-pivot-table/m-p/1218233#M23592 girirajsinh 2017-01-23T18:00:40Z