Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
May be use Match function
ex:
PRODOTI:
LOAD
name,
entities,
...........
FROM XXX.qvd
(qvd)
where Match(entities,"cards","collective","users");
Match
Match(Fieldname,'Value1','Value2'....)
Match(entities,('cards','collective','users')
Anil,
is field values should be in single quotes or double quotes?