Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
xarapre7
Creator II
Creator II

Filter out from a sheet

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!

1 Solution

Accepted Solutions
vishsaggi
Champion III
Champion III

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:

Capture.PNG

View solution in original post

6 Replies
william_allen
Contributor III
Contributor III

If you are using set analysis use -= to exclude

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

xarapre7
Creator II
Creator II
Author

Thanks for your quick reply William.

I tried it and I encountered this error.

Not applicable

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

or you can give expression as

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


-Ashok

vishsaggi
Champion III
Champion III

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:

Capture.PNG

william_allen
Contributor III
Contributor III

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
Creator II
Creator II
Author

This worked.  Thank you!