Suppress Null Value Rows

[#1]

I am trying to suppress rows where all expression values are null. I have both 'suppress zero values' and 'suppress missing' selected, but rows are still displaying. Any ideas on what could be causing this?

[Oleg_Troyansky]

are you sure all the expressions are rendering null()? I had similar problems when one of the expressions rendered an empty string - just a pair of single quotes with nothing inside. This is not considered a null(), and all those rows appeared...

[deepakk]

hi ,

It might contain space and space are not considered as null.

In Script you can modify the field as follows.

if(len(trim(Filed)) =0,null(), Field) as Field.

Now in front it should work.

[#4]

I have an if statement in all expressions to return null when a certain calculation equals zero.

[Oleg_Troyansky]

Kristy,

this should be unnecessary - QlikView should be able to exclude all zeros as well. Could you possibly post an example? Or a word document with the screen shots of all chart properties and expressions?

[#6]

Hi Kristy,

were you ever able to solve this problem, as I have the same issue.

Many thanks,

Lawrence