Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

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
gabriel_kirst
Contributor III

Re: How to filter Null Values in Script

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

2 Replies
gabriel_kirst
Contributor III

Re: How to filter Null Values in Script

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

Employee
Employee

Re: How to filter Null Values in Script

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);

Community Browser