Filter out from a sheet

[xarapre7]

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!

[william_allen]

If you are using set analysis use -= to exclude

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

[xarapre7]

Thanks for your quick reply William.

I tried it and I encountered this error.

[#4]

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

or you can give expression as

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

-Ashok

[vishsaggi · Accepted solution]

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:

[william_allen]

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)

OR

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

[xarapre7]

This worked.  Thank you!