Simulating a SQL "WHERE fieldname IN ()" in Qlikview

[lblancher]

Hi Everyone,

Is there any way to simulate a SQL WHERE IN clause in Qlikview? I have one table that I would like to make a subset table from based on a certain field. I have put the values that I would like the IN statement to use into a temporary table, but I don't know how to make the resident load filter by thoose values. This a rough syntax example, I know I would have other problems. I have looked at the exists function, but I don't belive it will work for my situtation because I want to have duplicate values based on what is in the original master table.

TEMPTABLE:
LOAD DISTINCT CITY
RESIDENT CITYTABLE
WHERE STATE = 'NY';

NY_TABLE:
LOAD PERSONSNAME
RESIDENT PEOPLE
WHERE PEOPLECITY IN (CITY);

Thank you,

Lucas

[biester]

Hi,

check

http://community.qlik.com/forums/p/19731/75357.aspx#75357

or

http://community.qlik.com/forums/p/20168/77156.aspx#77156

There are several approaches (match,exists ...)

Rgds,
Joachim