Discussion board where members can get started with QlikView.
I am looking to create a table which contains only the tuples that meet a simple if condition:
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.
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
Thanks for your reply.
I would like to suppress the rows that do not return a 'Yes' as per the above IF condition.
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.