topic where clause criterion syntax in QlikView

where clause criterion syntax

Mon, 13 Jun 2011 10:35:39 GMT

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

where clause criterion syntax

Mon, 13 Jun 2011 10:38:32 GMT

You can use

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

where clause criterion syntax

Mon, 13 Jun 2011 11:02:10 GMT

Blimey that was quick! And it works, too.

Thankyou very much for your help.

where clause criterion syntax

Wed, 29 Feb 2012 17:25:38 GMT

Thi was just what I needed... thanks