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: 
stevejones1
Contributor III
Contributor III

Allowing Nulls for Date Time field

Hi

I have a field "ClosedDateTime" , which has Nulls and Date time values

I need to filter the values above 05/01/2017 but when i use ClosedDateTime>= '05/01/2017' in the script its removing all the rows where

ClosedDateTime is Null also .. i want to have nulls at the same time filter dates by date


How do i do that?


Thanks!

1 Solution

Accepted Solutions
Nicole-Smith

Add an OR statement to your script:

ClosedDateTime>= '05/01/2017' OR IsNull(ClosedDateTime)

View solution in original post

1 Reply
Nicole-Smith

Add an OR statement to your script:

ClosedDateTime>= '05/01/2017' OR IsNull(ClosedDateTime)