topic Re: SQL IN Operator in QlikView

SQL IN Operator

Wed, 01 Feb 2017 09:09:13 GMT

what is the equivalent of SQL operator 'IN' in QlikView?

ex:

PRODOTI:

LOAD

name,

entities,

...........

FROM XXX.qvd

(qvd)

where entities in ("cards" "collective" "users"); --------> ??????????

thx!

Re: SQL IN Operator

Anil_Babu_Samineni — Wed, 01 Feb 2017 09:13:35 GMT

May be use Match function

ex:

PRODOTI:

LOAD

name,

entities,

...........

FROM XXX.qvd

(qvd)

where Match(entities,"cards","collective","users");

Re: SQL IN Operator

surendraj — Wed, 01 Feb 2017 09:14:37 GMT

Match

Match(Fieldname,'Value1','Value2'....)

Match(entities,('cards','collective','users')

Re: SQL IN Operator

surendraj — Wed, 01 Feb 2017 09:16:52 GMT

Anil,

is field values should be in single quotes or double quotes?