Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)
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