Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Excluding Nulls from expression

Hi all,

I am looking to create a table which contains only the tuples that meet a simple if condition:

     if(Date=LatestUpdate, 'Yes',NULL)

As a calculated dimension I could select the 'Surpress When Value Is Null' checkbox. How do I achieve the same result when using an expression?

The reason that I did not use a calculated dimension is that it resulted in a memory error.

Thanks,

Alan

Tags (3)
3 Replies
danielrozental
Honored Contributor II

Re: Excluding Nulls from expression

Sorry, I don't get it, null values in expressions are filtered by default.

The correct way to reference a null value is through the null function null().

     if(Date=LatestUpdate, 'Yes',NULL()) or

     if(Date=LatestUpdate, 'Yes')

Not applicable

Re: Excluding Nulls from expression

Hi Daniel,

Thanks for your reply.

I would like to suppress the rows that do not return a 'Yes' as per the above IF condition.

Thanks

Alan

danielrozental
Honored Contributor II

Re: Excluding Nulls from expression

Alan, a row in a table all graph tha has nulls on every expression will be filtered by default, make sure you have the following optin selected.

img10.png