topic Highlight cells in pivot table in QlikView https://community.qlik.com/t5/QlikView/Highlight-cells-in-pivot-table/m-p/718880#M1079872 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>When i tried to compare with plan with actual, the heading column also got highlighted and when the cell value is zero for both actual and plan , cell is being highlighted (subsequent months)</P><P></P><P>Kindly refer the below screen shot</P><P></P><P></P><P><IMG alt="Capture.JPG.jpg" class="jive-image" src="https://community.qlik.com/legacyfs/online/61804_Capture.JPG.jpg" style="width: 620px; height: 209px;" /></P></BODY></HTML> Sat, 05 Jul 2014 14:49:37 GMT 2014-07-05T14:49:37Z Highlight cells in pivot table https://community.qlik.com/t5/QlikView/Highlight-cells-in-pivot-table/m-p/718880#M1079872 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>When i tried to compare with plan with actual, the heading column also got highlighted and when the cell value is zero for both actual and plan , cell is being highlighted (subsequent months)</P><P></P><P>Kindly refer the below screen shot</P><P></P><P></P><P><IMG alt="Capture.JPG.jpg" class="jive-image" src="https://community.qlik.com/legacyfs/online/61804_Capture.JPG.jpg" style="width: 620px; height: 209px;" /></P></BODY></HTML> Sat, 05 Jul 2014 14:49:37 GMT https://community.qlik.com/t5/QlikView/Highlight-cells-in-pivot-table/m-p/718880#M1079872 2014-07-05T14:49:37Z Re: Highlight cells in pivot table https://community.qlik.com/t5/QlikView/Highlight-cells-in-pivot-table/m-p/718881#M1079873 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Just add isnull() or Exr&lt;&gt;0 exception for your highlight expression.</P><P>HTH.</P><P></P><P>Andrei</P></BODY></HTML> Wed, 06 Aug 2014 06:22:05 GMT https://community.qlik.com/t5/QlikView/Highlight-cells-in-pivot-table/m-p/718881#M1079873 crusader_ 2014-08-06T06:22:05Z Re: Highlight cells in pivot table https://community.qlik.com/t5/QlikView/Highlight-cells-in-pivot-table/m-p/718882#M1079874 <HTML><HEAD></HEAD><BODY><P> Try diz...</P><P></P><P><IMG alt="pic.JPG.jpg" class="jive-image" src="https://community.qlik.com/legacyfs/online/63824_pic.JPG.jpg" style="width: 620px; height: 548px;" /></P></BODY></HTML> Wed, 06 Aug 2014 10:16:37 GMT https://community.qlik.com/t5/QlikView/Highlight-cells-in-pivot-table/m-p/718882#M1079874 2014-08-06T10:16:37Z