topic Re: WHERE multiple values in QlikView

WHERE multiple values

mayer_stefan — Thu, 13 Aug 2020 07:49:49 GMT

Dear all,

I had a look at similar postings, but I think I got a problem because of combined WHERE conditions.

Script is working:

LOAD
...
WHERE SALESORG I EQ '0001',
/BIC/ZDATARTK I EQ LS,
CALMONTH I EQ $(vYearMonth)
;

Now I want to load not only SALESORG 0001, but also 0002 and 0003 (and don´t load any others).
This one doesn´t work, because WHERE MATCH is also for the following lines?

LOAD
...
WHERE MATCH(SALESORG,'0001','0002','0003)',
/BIC/ZDATARTK I EQ LS,
CALMONTH I EQ $(vYearMonth)
;

What is a suitable way to adapt the script?
Thanks a lot!

Stefan

Re: WHERE multiple values

eliran — Thu, 13 Aug 2020 08:56:09 GMT

Hi,

I'm not sure if a typo or not, but your where looks a bit off, the last apostrophe is after the brackets, and not before.

Yours:

WHERE MATCH(SALESORG,'0001','0002','0003)',

The correct one

WHERE MATCH(SALESORG,'0001','0002','0003'),

Re: WHERE multiple values

mayer_stefan — Thu, 13 Aug 2020 09:19:33 GMT

Hi,

thanks for your reply, and sorry that´s a typo.

LOAD
...
WHERE MATCH(SALESORG,'0001','0002','0003)',
/BIC/ZDATARTK I EQ LS,
CALMONTH I EQ $(vYearMonth)
;

What I mean is that these following lines still need WHERE instead of WHERE MATCH:
/BIC/ZDATARTK I EQ LS,
CALMONTH I EQ $(vYearMonth)
;

How to combine these conditions of WHERE MATCH and WHERE?