Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Where not match?

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

1 Solution

Accepted Solutions
Not applicable

Re: Where not match?

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

5 Replies
Not applicable

Re: Where not match?

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

Not applicable

Re: Where not match?

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

swarup_malli
Valued Contributor

Re: Where not match?

try

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

Not applicable

Re: Where not match?

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

swarup_malli
Valued Contributor

Re: Where not match?

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

Community Browser