Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Not applicable

Re: Removing Rows with Nulls

Thanks for the response, I am trying to Not load a row if any of the expression fields are Null, all Dimension fields in my script will contain 0 Nulls.

Not applicable

Re: Removing Rows with Nulls

When you say "script", it makes me think of when you are initially loading the data into QlikView.  The advice I gave is used in the chart design stage.

If I understand what you are saying, and you are designing a chart, then put all of those expressions into the hidden column I mentioned in the third part of my previous post.  I think something like the following would be helpful:

If(

IsNull(Expr1) = 0 AND IsNull(Expr2) = 0 AND IsNull(Expr3) = 0 ...etc.,

True(),

Null()

)

hirenp0904
New Contributor

Re: Removing Rows with Nulls

I am having the same problem with my straight table and i tried to supress missing but no change. I am trying the hide dimensions where my expressions are '-'

Re: Removing Rows with Nulls

The suppress missing on the Presentation makes the chart suppress values where the expression has a missing value. But you want to do it where the dimension has a missing (Null) value. You should set this on Chart properties -> Dimensions -> Suppress when value is Null.

HIC

hirenp0904
New Contributor

Re: Removing Rows with Nulls

Henric,

Actually i want to supress row where my expression has missing / null / blank value. My dimensions do not have any null values. However i tried with both the options but no luck.

swarnav999
New Contributor

Re: Removing Rows with Nulls

Works! Thank you.