SQL select in clause with a qvd load or resident load

[#1]

HI All

How do I a IN criteria for a qvd file load or a resident load?

for example, in sql i can have something like select * from table where title IN (select name from table2 where name IN ('open', 'close', 'other')

Thanks

[#2 · Accepted solution]

You want to use the match() function - I did a blog post about it last weekend if it helps

http://oneqlikatatime.blogspot.co.uk/2012/05/in-statements-in-qlikview-match.html

Chris

[#3]

I have tried to make that work before (and failed) and I do not believe there is an "IN" statement in QlikViews scripting.

Stephen

[#4]

Hi Stephen,

The match() function has a funny syntax but is definitely a comparative function to SQL in function.

Chris

[#5]

You are right, the match function does handle the "IN" funtionality.

Stephen