Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

jtovarsanchez
New Contributor II

FILTER NULL

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

ejemplo.png

2 Replies
justinvchiang
New Contributor III

Re: FILTER NULL

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
Esteemed Contributor III

Re: FILTER NULL

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.

Community Browser