topic Re: Where not match? in QlikView

Where not match?

Fri, 14 Nov 2014 21:02:35 GMT

I am importing an excel file that contains a few fields - one of them being zip_code. I would like to only import those rows from the excel file that do not contain a specific set of zip codes and for some reason nothing that I try works.

this is what I have as the where clause:

where not match(ZIP_CODE, 55555,44444,33333,22222);

does anybody know why this is not working? The script re-loads, but the zip codes are still there.

Thanks

Re: Where not match?

Fri, 14 Nov 2014 21:05:54 GMT

Have you tried: where match(ZIP_CODE, ........) = 0

Re: Where not match?

Fri, 14 Nov 2014 21:11:17 GMT

That doen't work either. The only thing that I have been able to get working is:

where ZIP_CODE <> 55555;

but that only works for one

Re: Where not match?

swarup_malli — Fri, 14 Nov 2014 21:13:36 GMT

try

where not match(ZIP_CODE, '55555','44444','33333','22222')

Re: Where not match?

Fri, 14 Nov 2014 21:14:44 GMT

Any chance the imported data is TEXT you need to wrap your zip codes with quotes '55555', '666666' etc?

Re: Where not match?

swarup_malli — Fri, 14 Nov 2014 21:15:56 GMT

You are missing quotes

Or you can create a Flag_ZIPCODE COLUMN in the excel

then

specify

where Flag_ZIPCODE <> '1'

here 1 corresponds to values you want to filter