Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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

3 Replies
danielrozental
Master II
Master II

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
Author

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
Master II
Master II

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