topic Re: Fix background colors on pivot chart in QlikView https://community.qlik.com/t5/QlikView/Fix-background-colors-on-pivot-chart/m-p/1269908#M516957 <HTML><HEAD></HEAD><BODY><P>Hi Sunny,</P><P></P><P>This works perfect, thank you so much.</P></BODY></HTML> Fri, 24 Mar 2017 02:26:49 GMT 2017-03-24T02:26:49Z Fix background colors on pivot chart https://community.qlik.com/t5/QlikView/Fix-background-colors-on-pivot-chart/m-p/1269906#M516955 <HTML><HEAD></HEAD><BODY><P>Dear Qlik Experts,</P><P></P><P>Attached is an app that I am testing. The pivot table has been color coded in the background.</P><P></P><P>However, when I click on the year selection, the color runs off, is there any way to make the color remains as it is?</P><P></P><P>The excel file is where the Qlik program is drawing the data from.</P></BODY></HTML> Thu, 23 Mar 2017 17:16:22 GMT https://community.qlik.com/t5/QlikView/Fix-background-colors-on-pivot-chart/m-p/1269906#M516955 2017-03-23T17:16:22Z Re: Fix background colors on pivot chart https://community.qlik.com/t5/QlikView/Fix-background-colors-on-pivot-chart/m-p/1269907#M516956 <HTML><HEAD></HEAD><BODY><P>Try this for your color</P><P></P><P><STRONG>=pick(num(<SPAN style="color: #ff0000;">Only({1}</SPAN>[impact pre]&amp;[likelihood pre]<SPAN style="color: #ff0000;">)</SPAN>),rgb(0,0,0), //ie 01</STRONG></P><P><STRONG>rgb(0,0,0),</STRONG></P><P><STRONG>rgb(0,0,0),</STRONG></P><P><STRONG>rgb(0,0,0),</STRONG></P><P><STRONG>rgb(0,0,0),</STRONG></P><P><STRONG>rgb(0,0,0),</STRONG></P><P><STRONG>rgb(0,0,0),</STRONG></P><P><STRONG>rgb(0,0,0),</STRONG></P><P><STRONG>rgb(0,0,0),</STRONG></P><P><STRONG>rgb(0,0,0),//10</STRONG></P><P><STRONG>...</STRONG></P></BODY></HTML> Thu, 23 Mar 2017 17:19:28 GMT https://community.qlik.com/t5/QlikView/Fix-background-colors-on-pivot-chart/m-p/1269907#M516956 sunny_talwar 2017-03-23T17:19:28Z Re: Fix background colors on pivot chart https://community.qlik.com/t5/QlikView/Fix-background-colors-on-pivot-chart/m-p/1269908#M516957 <HTML><HEAD></HEAD><BODY><P>Hi Sunny,</P><P></P><P>This works perfect, thank you so much.</P></BODY></HTML> Fri, 24 Mar 2017 02:26:49 GMT https://community.qlik.com/t5/QlikView/Fix-background-colors-on-pivot-chart/m-p/1269908#M516957 2017-03-24T02:26:49Z