How to exclude an option from the filter?

[Anonymous]

Hi, I want to exclude one of the options from a filter in Qlikview. The option i am trying to exclude has blank values in the data source. Can any of you help me with this please?

[OmarBenSalem]

u can do as follow:

if(len(trim(YourDim))=0,null(), YourDim) and put it as a filter; and do not show null values

[Chanty4u]

can you give more details on your filter values?

what exactly filter has? and what is your output should be?

[Gysbert_Wassenaar]

You could set the blanks to nulls in the script. Imho a better option is to replace the blanks with another value like 'n/a' or 'no value'

[Anonymous]

so currently the blank values are set as 'n/a'. 'N/A' is appearing as one of the filter options for a particular category. I want to exclude 'N/A' from the filter panel.

[OmarBenSalem]

as a filter;

if(yourDim='N/A', null(), yourDim)

[agigliotti]

you can use an expression as below in your filter:

Aggr( if( yourField = 'N/A', null(), yourField ), yourField )