topic Re: Excluding Nulls from expression in QlikView

Excluding Nulls from expression

Tue, 22 Jan 2013 10:23:26 GMT

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

danielrozental — Tue, 22 Jan 2013 12:27:17 GMT

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')

Tue, 22 Jan 2013 14:59:07 GMT

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 — Tue, 22 Jan 2013 17:56:35 GMT

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.