FILTER NULL

[Anonymous]

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

[justinvchiang]

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]

Check here?

NULL handling in QlikView

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.