Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for 
Search instead for 
Did you mean: 
villegasi03
Creator
Creator

Qlikview Statement thats the same as SQL IN statement

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?

1 Solution

Accepted Solutions
Sokkorn
Master
Master

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

View solution in original post

3 Replies
Sokkorn
Master
Master

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

View solution in original post

Not applicable

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

villegasi03
Creator
Creator
Author

Thanks everyone for the help. this worked great!