topic Suppress Null Value Rows in QlikView

Suppress Null Value Rows

Mon, 11 Apr 2011 23:32:42 GMT

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?

Suppress Null Value Rows

Oleg_Troyansky — Tue, 12 Apr 2011 03:45:07 GMT

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...

Suppress Null Value Rows

deepakk — Tue, 12 Apr 2011 04:47:21 GMT

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.

Suppress Null Value Rows

Tue, 12 Apr 2011 16:40:53 GMT

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

Suppress Null Value Rows

Oleg_Troyansky — Tue, 12 Apr 2011 17:58:17 GMT

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?

Suppress Null Value Rows

Fri, 30 Mar 2012 12:26:52 GMT

Hi Kristy,

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

Many thanks,

Lawrence