Filter tool - multiple exclusions

[qgpl]

Hi

Sorry if this seems such a beginner question. I've tried a few ways to find out how I can use the filter button to exclude multiple items but I really can't get it to work. 

For e.g. I need to exclude account numbers 11111,22222,33333,44444. I tried:

[Account Number] != "11111","22222","33333","44444" also tried with single quotes

[Account Number] != ("11111","22222","33333","44444" )

!Contains([Account Number],""11111","22222","33333","44444")

Also a few others but nothing worked. Do I have to use the filter tool for each account number?

Thank you

[ShankerV · Accepted solution]

Hi @qgpl 

One way of doing this,

Even we can use IN condition also.

[ShankerV]

Hi @qgpl 

Another way to do this using IN.

Many thanks

Shanker V

[dkma]

Hi 

Try this instead in filter

[Account Number] NOT IN ("11111","22222","33333","44444")

if the [Account Number] is in Integer [Account Number] NOT IN (11111,22222,33333,44444)

Thanks!

[binu_acs]

@qgpl 

[qgpl]

Thank you all so much - these worked perfectly!!! 😁