SQL IN Operator

[#1]

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!

[Anil_Babu_Samineni]

May be use Match function

ex:

PRODOTI:

LOAD

name,

entities,

...........

FROM XXX.qvd

(qvd)

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

[surendraj]

Match

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

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

[surendraj]

Anil,

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