topic Lookup with Multiple Criteria in QlikView

Lookup with Multiple Criteria

samuel_brierley — Thu, 12 Nov 2015 08:53:07 GMT

Hi guys,

is it possible to have a lookup in the script with multiple criteria and if so can someone explain the Syntax?

i am trying to lookup a value from a different table in the script e,g

Table1

Table2

[1],[2][3]

Table 3

[1]

lookup( ,

where 2 > and 2 < and [3] > and [3] < ,

Table1)

swuehl — Thu, 12 Nov 2015 12:15:23 GMT

If the amount of records won't blow your system, you can do something like this:

TMP:

LOAD ,,,, RESIDENT Table1;

JOIN (TMP)

LOAD [1],[2],[3] RESIDENT Table2;

RESULT:

RESIDENT TMP

WHERE [2] > AND [2] < AND [3] > AND [3] < ;

Anonymous — Thu, 12 Nov 2015 12:19:13 GMT

you might get some idea from following threads: