topic How to filter Null Values in Script in QlikView

How to filter Null Values in Script

Mon, 06 Oct 2014 14:41:41 GMT

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

Anonymous — Mon, 06 Oct 2014 14:54:00 GMT

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 — Mon, 06 Oct 2014 14:58:11 GMT

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