topic Re: Filter out from a sheet in QlikView

Filter out from a sheet

xarapre7 — Wed, 25 Nov 2020 16:16:04 GMT

Hi All!

I have a long list of countries and i would like to filter out just 3 countries from a sheet. Is this done in the sheet properties as a trigger? What should be the right expression?

Thank you for your help in advance!

Re: Filter out from a sheet

william_allen — Wed, 14 Dec 2016 16:01:35 GMT

If you are using set analysis use -= to exclude

country -= {'Ireland','England','Wales'}

Re: Filter out from a sheet

xarapre7 — Wed, 14 Dec 2016 16:08:36 GMT

Thanks for your quick reply William.

I tried it and I encountered this error.

Re: Filter out from a sheet

Wed, 14 Dec 2016 16:13:00 GMT

Even if it shows as error, it should work. Try hitting apply.

or you can give expression as

country= {'*'} - {'Ireland','England','Wales'}

-Ashok

Re: Filter out from a sheet

vishsaggi — Wed, 14 Dec 2016 16:15:27 GMT

Why dont you use a listbox for country with filtered countrynames? Taking william example

Add a list box and use this expression

= IF(NOT Match(Country, 'Ireland', 'England', 'Wales'), Country)

Here:

Re: Filter out from a sheet

william_allen — Wed, 14 Dec 2016 16:24:48 GMT

Sorry I should have explained, my example was to be used in any set analysis within your sheet where you wanted to exclude the countries. For example

Sum({<year = {2016}, month={'Jan'}, country -= {'Ireland','England','Wales'}>} Customer_id)

Sum({<year = {2016}, month={'Jan'}, country = {*} - {'Ireland','England','Wales'}>} Customer_id)

Re: Filter out from a sheet

xarapre7 — Wed, 14 Dec 2016 16:27:44 GMT

This worked. Thank you!