Discussion Board for collaboration on QlikView Layout & Visualizations.
Can someone tell me how to filter the data that is empty please, clicking on an empty cell does nothing
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.
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.