topic Re: What are the advantages of Applymap() over lookup() in QlikView

What are the advantages of Applymap() over lookup()

Mon, 25 Mar 2013 13:40:27 GMT

What are the advantages of Applymap() over lookup() ???

Thanks & Regards

Satti

Re: What are the advantages of Applymap() over lookup()

swuehl — Mon, 25 Mar 2013 14:00:46 GMT

I believe applymap() could show a much better performance, since it can be potentially executed on the distinct values only, not per table record.

Re: What are the advantages of Applymap() over lookup()

Mon, 25 Mar 2013 14:31:27 GMT

Hi,

For lookup function see the below url :

http://community.qlik.com/message/56804#56804

Best of luck

Re: What are the advantages of Applymap() over lookup()

Gabriel — Mon, 25 Mar 2013 14:33:29 GMT

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://qlikshare.com/194

http://www.quickintelligence.co.uk/applymap-is-it-so-wrong/

Regards,

Gabriel

Re: What are the advantages of Applymap() over lookup()

Anonymous — Mon, 25 Mar 2013 14:43:50 GMT

One more: http://community.qlik.com/docs/DOC-3903

Re: What are the advantages of Applymap() over lookup()

hic — Tue, 26 Mar 2013 09:53:37 GMT

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

Re: What are the advantages of Applymap() over lookup()

Thu, 28 Mar 2013 15:03:04 GMT

Thanks Henric

Re: What are the advantages of Applymap() over lookup()

Thu, 28 Mar 2013 15:03:24 GMT

Thanks Everyone