topic Null values in pivot table in QlikView https://community.qlik.com/t5/QlikView/Null-values-in-pivot-table/m-p/630571#M231437 <HTML><HEAD></HEAD><BODY><P><BR />Hi All,</P><P>I am using one Pivot table. It contains 2 dimension Product, Color and 1 Expression Sum(Price). Product dimension having some null values so I want to background turn green for Product coumn if it was having null value. I wrote one expression under background of Product Dimension :&nbsp; if(Product = Null(), Green())&nbsp;&nbsp;&nbsp; but it is not working. Please help me.</P><P>Sample application is attached.</P></BODY></HTML> Wed, 28 May 2014 09:17:39 GMT soha1902 2014-05-28T09:17:39Z Null values in pivot table https://community.qlik.com/t5/QlikView/Null-values-in-pivot-table/m-p/630571#M231437 <HTML><HEAD></HEAD><BODY><P><BR />Hi All,</P><P>I am using one Pivot table. It contains 2 dimension Product, Color and 1 Expression Sum(Price). Product dimension having some null values so I want to background turn green for Product coumn if it was having null value. I wrote one expression under background of Product Dimension :&nbsp; if(Product = Null(), Green())&nbsp;&nbsp;&nbsp; but it is not working. Please help me.</P><P>Sample application is attached.</P></BODY></HTML> Wed, 28 May 2014 09:17:39 GMT https://community.qlik.com/t5/QlikView/Null-values-in-pivot-table/m-p/630571#M231437 soha1902 2014-05-28T09:17:39Z Re: Null values in pivot table https://community.qlik.com/t5/QlikView/Null-values-in-pivot-table/m-p/630572#M231438 <HTML><HEAD></HEAD><BODY><P>You can not test for NULL using Product=Null(). Instead you should use IsNull(Product).</P><P></P><P>See more here:<A href="https://community.qlik.com/docs/DOC-3155">NULL handling in QlikView</A></P><P></P><P>HIC</P></BODY></HTML> Wed, 28 May 2014 09:22:10 GMT https://community.qlik.com/t5/QlikView/Null-values-in-pivot-table/m-p/630572#M231438 hic 2014-05-28T09:22:10Z