topic Qlikview Statement thats the same as SQL IN statement in QlikView

Qlikview Statement thats the same as SQL IN statement

villegasi03 — Wed, 06 Jun 2012 00:43:58 GMT

QV Users,

Is there a Qlikview statement that I can use that does the same as a SQL IN Statement. I am using a variable that is assigned a string that I use in IN sql statements. It works great because I can avoid the "field = 'value' or "field = value2" ect. thing. Any suggestions?

Qlikview Statement thats the same as SQL IN statement

Sokkorn — Wed, 06 Jun 2012 01:06:05 GMT

Hi,

Where MATCH(Field,'Val1','Val2','Val3') in QlikView will return the result like SQL IN statement. Let try it and do let me know.

Regards,

Sokkorn

Qlikview Statement thats the same as SQL IN statement

Wed, 06 Jun 2012 08:06:16 GMT

LOAD * WHERE MATCH(field,'value','value2');

Qlikview Statement thats the same as SQL IN statement

villegasi03 — Wed, 06 Jun 2012 12:15:03 GMT

Thanks everyone for the help. this worked great!