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 clause criterion syntax

I was a bit surprised when I tried -

load * from wherever.qvd where fieldname in (valuelist);

and got the "garbage after statement" error.  When I took out the "in" and replaced it with an equals sign it was happy.  Can I not use "in" in a load statement where clause?  Or did I get the syntax wrong?

Does anybody have the criterion syntax or a better way around this than lots of "or" statements?

Cheers,

Colin

1 Solution

Accepted Solutions
Not applicable

where clause criterion syntax

Hi

You can use

load * from wherever.qvd where match(fieldname,value1,value2,...);

3 Replies
Not applicable

where clause criterion syntax

Hi

You can use

load * from wherever.qvd where match(fieldname,value1,value2,...);

Not applicable

where clause criterion syntax

Blimey that was quick!  And it works, too.

Thankyou very much for your help.

Not applicable

where clause criterion syntax

Thi was just what I needed... thanks

Community Browser