Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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
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
LOAD * WHERE MATCH(field,'value','value2');
Thanks everyone for the help. this worked great!