topic FILTER NULL in QlikView

FILTER NULL

Anonymous — Wed, 13 Dec 2017 22:04:14 GMT

Can someone tell me how to filter the data that is empty please, clicking on an empty cell does nothing

justinvchiang — Wed, 13 Dec 2017 22:38:30 GMT

If ESTATUS is a dimension you could eliminate Null values in your load script by loading it as:

, if(IsNull(ESTATUS), 'No Status', ESTATUS) as ESTATUS

Then you could filter on 'No Status' within your chart.

vishsaggi — Wed, 13 Dec 2017 22:54:43 GMT

Check here?

User NullASValue as one of the ways to handle. Like

NULLASVALUE Field1, Field2, Field3;

SET NullValue = '<NoData>';

Your Actual Load Script.

Then when you display the fields as Listbox you should see NoData where ever there are nulls.