topic Vlookup in Chart in QlikView

Vlookup in Chart

reddwarfcrew — Sat, 16 Nov 2024 19:03:23 GMT

Hi, I have a table of Data as per below. I'd like to do a lookup to find the ParentName based on the ParentID. I know how to do this in the script, but is it possible to do i the chart itself?

ID	Name	ParentID
1	A	2
2	B	3
3	C	3

ie, the equivalent of excel's@ Vlookup(ParentID,ID:Name,2,0)

So the new dimenstion in the chart would return

ID	Name	ParentID	ParentName
1	A	2	B
2	B	3	C
3	C	3	C

I've tried a few things (like Below function, but this only seems to work on numbers)

Re: Vlookup in Chart

jochem_zw — Mon, 24 Feb 2020 14:51:46 GMT

no this is not possible, you should do a applymap in the script to get the ParentName on row level

Re: Vlookup in Chart

Brett_Bleess — Thu, 26 Mar 2020 12:52:58 GMT

Try searching the Design Blog area of the Community for further ideas on how else to approach things:

https://community.qlik.com/t5/Qlik-Design-Blog/bg-p/qlik-design-blog

Regards,
Brett