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?
u can do as follow:
if(len(trim(YourDim))=0,null(), YourDim) and put it as a filter; and do not show null values
can you give more details on your filter values?
what exactly filter has? and what is your output should be?
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'
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.
as a filter;
if(yourDim='N/A', null(), yourDim)
you can use an expression as below in your filter:
Aggr( if( yourField = 'N/A', null(), yourField ), yourField )
Retrieving data ...