Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

If with Null comparison

Hi All,

I have expression as below. I have to compare if the status is null. How can I make.

=if(Id<>1,date(StatusDate), if(Status='Status1', 'ST1',if(Status is null, 'BLANK',date(StatusDate))))

It is giving expression error. If my status field no value I want to show'BLANK'.

Thanks..

2 Replies
maxgro
MVP
MVP

len(trim(Status))>0     not null

Anonymous
Not applicable
Author

You can use "IsNull(Status)"

Regards,
Gabriel