topic Re: Lookup doesnt work??? in QlikView

Lookup doesnt work???

samuel_brierley — Wed, 28 May 2014 14:41:59 GMT

Hi all

im trying to use a lookup for a reference line and the function isnt recognised by qlikview, any help?

thanks alot

Re: Lookup doesnt work???

rwunderlich — Wed, 28 May 2014 14:43:43 GMT

Do you mean the lookup() function? That is only supported in script, not in charts.

-Rob

Re: Lookup doesnt work???

samuel_brierley — Wed, 28 May 2014 14:45:19 GMT

ahh right that could be why then,

is there an equivelent that works in charts?

basically I have a 2 collumn table and i want to perform essentially a vlookup on it.

Re: Lookup doesnt work???

Wed, 28 May 2014 14:46:47 GMT

As Rob says, there is no Lookup() function in charts, but you can work around using only() and set analysis.

Say you are looking up customer and country. Put in the set analysis to ignore all selections, using the '1' just in case. Then set the field you are looking for to the lookup vaule.

= only({1<Customer={"customer name"}>} Country)

The only() function will now return the country for that particular customer

Erica

Re: Lookup doesnt work???

Wed, 28 May 2014 14:47:55 GMT

BTW what are you trying to do? Becayse in the app, QlikView might just join the fields together for you anyway. Is this not working?

Erica

Re: Lookup doesnt work???

samuel_brierley — Wed, 28 May 2014 14:50:45 GMT

Ahh thank you thats what im after

thank you!

Re: Lookup doesnt work???

Wed, 28 May 2014 15:33:04 GMT

No worries