topic Re: Filter Multiple values in script in QlikView

Filter Multiple values in script

ashishpalkar — Fri, 06 Nov 2015 14:49:32 GMT

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 — Fri, 06 Nov 2015 14:52:24 GMT

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

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

alexandros17 — Fri, 06 Nov 2015 14:56:22 GMT

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 — Fri, 06 Nov 2015 14:59:26 GMT

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

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 — Fri, 06 Nov 2015 15:00:30 GMT

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 — Fri, 06 Nov 2015 15:09:45 GMT

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