Filter Multiple values in script

[ashishpalkar]

Hi There

I am looking filter multiple values in script, i tried using <> sign.

what will be the correct syntax?

E.g

Country <> 'UK' and US and 'AU'

and

ID <> '1100' and '2200' and '3300'

Thanks in advance

[swuehl]

NOT MATCH(Country, 'UK', 'US', 'AU')

NOT MATCH(ID,'1100','2200','3300')

[alexandros17]

If you want Country different from UK and different from US and AU then

...

Where Country <> 'UK' and Country <> 'US' and Country <> 'AU'

if you need that at leadt one can be different then

...

Where Country <> 'UK' orCountry <> 'US' or Country <> 'AU'

The same for item ...

let me know

[Anonymous]

If you want to load only certain values from a table dimension use the 'where' expression in the loading script. See:

Load Where.

You can also use the set analysis to show / exclude selected fields in your calculations

eg.

=sum({$<CustomerID-={'0056'}>} InvoiceAmt)

notice the '-' before the '=' to exclude values.

[gsbeaton · Accepted solution]

Hi Ashish

You can use the MATCH() keyword combined with NOT, eg

WHERE NOT MATCH(Country, 'UK,US,AU')  AND  NOT MATCH(ID, '1100,2200,3300');

Hope that helps,

George

[ashishpalkar]

Thanks all, WHERE NOT MATCH(Country, 'UK,US,AU')  AND  NOT MATCH(ID, '1100,2200,3300') worked well.