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?
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.