topic Background Color in a Pivot Table in QlikView https://community.qlik.com/t5/QlikView/Background-Color-in-a-Pivot-Table/m-p/1405462#M425647 <HTML><HEAD></HEAD><BODY><P>I am trying to make my background a different color based on a value in a dimension.&nbsp; For example if it's Open it's yellow, Won it's green and Lost it's red.&nbsp; The color is coming through on the first value in the dimension, but not the rest. Any ideas?&nbsp; Here is the background logic I used for the dimension.</P><P></P><P><SPAN style="font-size: 14pt;">=</SPAN><SPAN style="font-size: 14pt;"><SPAN style="color: #0000ff;">if</SPAN>(<SPAN style="color: #800000;">OPStateDesc</SPAN> = 'Open',<SPAN style="color: #0000ff;">Yellow</SPAN>(),<BR />&nbsp; <SPAN style="color: #0000ff;">if</SPAN>(<SPAN style="color: #800000;">OPStateDesc</SPAN> = 'Won',<SPAN style="color: #0000ff;">Green</SPAN>(),<BR />&nbsp; <SPAN style="color: #0000ff;">If</SPAN>(<SPAN style="color: #800000;">OPStateDesc</SPAN> = 'Lost',<SPAN style="color: #0000ff;">Red</SPAN></SPAN><SPAN style="font-size: 14pt;">()))) </SPAN></P></BODY></HTML> Thu, 30 Nov 2017 16:02:21 GMT tmumaw 2017-11-30T16:02:21Z Background Color in a Pivot Table https://community.qlik.com/t5/QlikView/Background-Color-in-a-Pivot-Table/m-p/1405462#M425647 <HTML><HEAD></HEAD><BODY><P>I am trying to make my background a different color based on a value in a dimension.&nbsp; For example if it's Open it's yellow, Won it's green and Lost it's red.&nbsp; The color is coming through on the first value in the dimension, but not the rest. Any ideas?&nbsp; Here is the background logic I used for the dimension.</P><P></P><P><SPAN style="font-size: 14pt;">=</SPAN><SPAN style="font-size: 14pt;"><SPAN style="color: #0000ff;">if</SPAN>(<SPAN style="color: #800000;">OPStateDesc</SPAN> = 'Open',<SPAN style="color: #0000ff;">Yellow</SPAN>(),<BR />&nbsp; <SPAN style="color: #0000ff;">if</SPAN>(<SPAN style="color: #800000;">OPStateDesc</SPAN> = 'Won',<SPAN style="color: #0000ff;">Green</SPAN>(),<BR />&nbsp; <SPAN style="color: #0000ff;">If</SPAN>(<SPAN style="color: #800000;">OPStateDesc</SPAN> = 'Lost',<SPAN style="color: #0000ff;">Red</SPAN></SPAN><SPAN style="font-size: 14pt;">()))) </SPAN></P></BODY></HTML> Thu, 30 Nov 2017 16:02:21 GMT https://community.qlik.com/t5/QlikView/Background-Color-in-a-Pivot-Table/m-p/1405462#M425647 tmumaw 2017-11-30T16:02:21Z