topic Re: In Clause in Qlikview in QlikView

In Clause in Qlikview

Tue, 03 Dec 2013 13:17:38 GMT

Hi,

Please tell me how can the "in" clause is used in qlikview?

Is there any option available to use the "in" clause in qlikview?

bbi_mba_76 — Tue, 03 Dec 2013 13:22:45 GMT

Hi,

if you are looking for

Field in ('A','B','C')

you could use

match(Field, 'A','B','C')>=1

Tue, 03 Dec 2013 13:22:58 GMT

Load a field

Use where exists()

Fabrice

Anonymous — Tue, 03 Dec 2013 13:23:41 GMT

I assume you mean the SQL "in". If correct, see match() function:

match(field, 'value1', 'value2', 'value3',...)

It returns 0 (false) if none of the values exist in the field. Otherwise it returns the number of the matching value, which is not 0 (hence "true").

Regards,

Michael

Fri, 06 Dec 2013 06:02:03 GMT

Thank you very much.

Match function did worked.