topic Where condition using 'IN' 'LOAD' in QlikView

Where condition using 'IN' 'LOAD'

boorgura — Tue, 25 May 2010 18:07:27 GMT

Hi Qlikers,

As we do in SQL:

Select <f1>, <f2> from abc where <f1> IN (Select <f1> from def)

Can we do a similar execution using the LOAD in Qlikview.

LOAD <f1>, <f2> resident abc where <f1> IN (LOAD <f1> resident def)

Did not research a lot. Thought first I will ask you guys.

Where condition using 'IN' 'LOAD'

Oleg_Troyansky — Tue, 25 May 2010 19:14:37 GMT

Rocky,

unfortunately, "IN" functionality is not implemented in QlikView. You can use somewhat similar exists(), only keep in mind that the comparizon is performed at the field level, as opposed to a table level. If you have to ensure that you are comparing to existing values of a field in a specific table, make the field unique to tha table (in other words, if you compare to a key field, create another copy of the same field just in the desired table, and compare to the copied field instead.

Re. :Re: Where condition using 'IN' 'LOAD'

Wed, 26 May 2010 07:42:40 GMT

I use match instead

match( s, expr1 [ , expr2, ...exprN ] )

Compares the string s to a list of strings or string expressions. The
result of the comparison is an integer indicating which of the comparison
strings/expressions matched. If no match is found, 0 is
returned. The match function performs a case sensitive comparison.
Examples:
match( M , 'Jan' , 'Feb' , 'Mar' )
where M is 'Feb' returns 2
match( M , 'Jan' , 'Feb' , 'Mar' )
where M is 'Apr' or 'jan' returns 0

Re. :Re: Where condition using 'IN' 'LOAD'

boorgura — Wed, 26 May 2010 15:12:47 GMT

I would do the same thing if it were a limited standard set of values to compare with.

But that is all the data for a given date.

So, I would assume this not to be solution for it.