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: 
Not applicable

How to filter Null Values in Script

Hi All,

Please find the attached excel file.

I need to filter the null values alone in edit script.(Date Not Filled Records in attached excel file).

Kindly help me on this query.

Regards,

Sivasu

1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

Hi!

You can use where IsNull(Date) = true() to bring all the values that the Date are null;

Or where IsNull(Date) = false() to bring the oposite.

Regards,

Gabriel

View solution in original post

2 Replies
Anonymous
Not applicable
Author

Hi!

You can use where IsNull(Date) = true() to bring all the values that the Date are null;

Or where IsNull(Date) = false() to bring the oposite.

Regards,

Gabriel

JonnyPoole
Employee
Employee

As above, this will only bring in the rows of data where Date is not null:

LOAD ItemNo,

     Month,

     Date

FROM

  (ooxml, embedded labels, table is Sheet1)

where not IsNull(Date);