Null values in pivot table

[soha1902]

Hi All,

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 :  if(Product = Null(), Green())    but it is not working. Please help me.

Sample application is attached.

[hic · Accepted solution]

You can not test for NULL using Product=Null(). Instead you should use IsNull(Product).

See more here:NULL handling in QlikView

HIC