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: 
manju421
Contributor II
Contributor II

How to compare date with null values

IMG_20201124_170055__01__01.jpg

I need a if statement using which, I can fetch all 4 version. Is there anyway through which I can get version 1. In every case for version 1..Date2 will be null

2 Replies
MayilVahanan

Hi @manju421 

Are you trying to replace null values of Date2 with Date1?

If so, try like below

if(Len(Trim(Date2))=0, Date1, Date2) 

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
manju421
Contributor II
Contributor II
Author

No, I want to display null value.

Screenshot_20201125-131526.jpg