Table Will Not Hide Null Values

[RiAi16]

Hello. I have a data table for which a number of records only show null values.

I've unticked the "Include Null Values" option and typically this would solve my issue and hide all records with null values.

However, on this occasion, nothing happened and all records remained visible.

The next thing that crossed my mind was that maybe some of the values weren't actually null.

I, therefore, adjusted the formulas of all my expressions with an IF() and NULL() functions, so all the values are null.

Why does the table keep displaying them?

Can someone help me solve this issue?

[rwunderlich · Accepted solution]

I believe the "Include null values" refers to null values in the DImension field, not the Measure.  In your case you want to uncheck "Include zero values" in the chart Data Handling section.

-Rob
http://www.easyqlik.com
http://masterssummit.com
http://qlikviewcookbook.com

[RiAi16]

Thank you, it worked!