Discussion board where members can get started with QlikView.
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?
Add an OR statement to your script:
ClosedDateTime>= '05/01/2017' OR IsNull(ClosedDateTime)
View solution in original post