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

lblancher — Tue, 15 Sep 2009 06:17:11 GMT

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

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

biester — Tue, 15 Sep 2009 11:31:02 GMT

Hi,

check

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

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

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

Rgds,
Joachim

topic AW:Simulating a SQL "WHERE fieldname IN ()" in Qlikview in QlikView

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

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