Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

gshroff21
New Contributor

How to exclude an option from the filter?

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?

6 Replies
omarbensalem
Esteemed Contributor

Re: How to exclude an option from the filter?

u can do as follow:

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

Highlighted
sureshqv
Esteemed Contributor III

Re: How to exclude an option from the filter?

can you give more details on your filter values?

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

Re: How to exclude an option from the filter?

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'


talk is cheap, supply exceeds demand
gshroff21
New Contributor

Re: How to exclude an option from the filter?

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

Re: How to exclude an option from the filter?

as a filter;

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

agigliotti
Honored Contributor II

Re: How to exclude an option from the filter?

you can use an expression as below in your filter:

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