Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
The #1 reason QlikView customers adopt Qlik Sense is a desire for a modern BI experience. Read More
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted

Add an OR statement to your script:

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

View solution in original post

1 Reply
Highlighted

Add an OR statement to your script:

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

View solution in original post