Discussion Board for collaboration on QlikView Layout & Visualizations.
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.
Go to Solution.
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.
As above, this will only bring in the rows of data where Date is not null:
(ooxml, embedded labels, table is Sheet1)
where not IsNull(Date);