Solved: Re: Lookup Function - Qlik Community

Report Inappropriate Content · ‎2014-06-10

Hi,

Now that the Lookup() function is gone, how do I do an easy lookup?

Unique ID	ColA	ColB	ColC
1	xxx	yyy	zzz
2	rrr	sss	ttt
3	uuu	vvv	www

Say I have id=2 and col='ColC'. How do I get to 'ttt' now without creating millions of mapping tables?

Thanks!

IAMDV · ‎2014-06-10

Have you tried using Only() function with Set Expression?

Cheers,

DV

anbu1984 · ‎2014-06-10

Try this

If(id=2,pick(match(col,'ColA','ColB','ColC'),ColA,ColB,ColC))

rbecher · ‎2014-06-10

Hi (number),

why not just using QlikView's Lookup() function?

- Ralf

Data & AI Engineer at Orionbelt.ai - a GenAI Semantic Layer Venture, Inventor of Astrato Engine

Report Inappropriate Content · ‎2014-06-10

Because I don't think Lookup exists anymore in my version?

Thanks!
Oli

Report Inappropriate Content · ‎2014-06-10

That's just hardcoding it... What if id=24343 and col=ColXY?

rbecher · ‎2014-06-10

Why? Which version?

Data & AI Engineer at Orionbelt.ai - a GenAI Semantic Layer Venture, Inventor of Astrato Engine

Report Inappropriate Content · ‎2014-06-10

As far as I know the lookup function still exists?

Report Inappropriate Content · ‎2014-06-10

QV11... Doesn't come up!

Thanks

Oli

Report Inappropriate Content · ‎2014-06-10

See above...

Report Inappropriate Content · ‎2014-06-10

That's actually really strange, I can see it in my help menu but I see the same problem you do...