topic vlookup in pivot in QlikView

vlookup in pivot

Mon, 23 Feb 2015 11:13:54 GMT

I need to do lookup to get the result as below marked red column - in excel i would do vlookup(LAST_RMA, RMA:REASON,2,0)

on script level I would do following:

Lookup('REASON', 'RMA',LAST_RMA,'DATA') AS LAST_REASON

but do to the size of data I would prefer to do this in pivot table and not on script basis. I tried match or wild match but nothing seems to work Can you help?

Need to lookup the REASON_ALL if LAST RMA = RMA

RMA	REASON	LAST_RMA	LAST_REASON
100	N01
101	R06	100	N01
102	R06	101	R06
103	R10	102	R06
104	R06	103	R10
105	R05	104	R06
106	R05	105	R05

Re: vlookup in pivot

robert_mika — Mon, 23 Feb 2015 11:41:59 GMT

use

Above(LAST_REASON,0,1)

PS.Polska?

Re: vlookup in pivot

Mon, 23 Feb 2015 12:17:50 GMT

Maybe I was not clear enough but LAST_REASON I just calculated in script as example using

Lookup('REASON', 'RMA',LAST_RMA,'DATA') AS LAST_REASON

but I would likle to calculate LAST_REASON in Pivot table or straigt table in the way that i don't need to do it in script. Your way is using LAST_REASON calculated already in script,

PS. Tak Polska

Re: vlookup in pivot

yura_ratu — Mon, 23 Feb 2015 13:03:27 GMT

Hi Anna,

In fact, you don't need vlookup function here. Just change the link field. Try this script