In Clause in Qlikview

[#1]

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]

Hi,

if you are looking for

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

you could use

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

[#3]

Load a field

Use where exists()

Fabrice

[Anonymous]

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

[#5]

Thank you very much.

Match function did worked.