Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
What are the advantages of Applymap() over lookup() ???
Thanks & Regards
Satti
I believe applymap() could show a much better performance, since it can be potentially executed on the distinct values only, not per table record.
Hi,
ApplyMap certainly has performance advantage but it depend on what you want to achieve.
Here are couple of blog to read and watch to help you make up your mind about ApplyMap vs Lookup
http://www.quickintelligence.co.uk/applymap-is-it-so-wrong/
Regards,
Gabriel
One more: http://community.qlik.com/docs/DOC-3903
There are two advantages:
1) Applymap is faster
2) Applymap is easier to understand - I always have to think carefully before I manage to write a correct Lookup call, but with Applymap it is always right on first try.
See more on http://community.qlik.com/docs/DOC-3412
HIC
Thanks Henric
Thanks Everyone