topic Re: apply map in QlikView

apply map

prabhas277 — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

which one is good in qlikview applymap or join?

Please explain the apply map with example?

Kushal_Chawda — Sun, 06 Mar 2016 05:53:55 GMT

see the below link

ashfaq_haseeb — Sun, 06 Mar 2016 07:25:02 GMT

Hi,

Wherever possible go with Applymap().

Regards

ASHFAQ

jonathandienst — Sun, 06 Mar 2016 11:16:25 GMT

They serve slightly different purposes.

ApplyMap is a simple lookup - it is functionally the same as a a Vlookup/Hlookup in Excel.
Join is analogous to a SQL join, in that you can filter on a join (using LEFT, RIGHT, or INNER), and add extra rows as well as columns, such as in an OUTER join, or where the join table has multiple rows matching the key.

In general, ApplyMap() is the quickest solution, so avoid doing lookups using a join, but use a join when it is appropriate.

engishfaque — Mon, 07 Mar 2016 03:40:10 GMT

Dear Prabhas,

Kindly find attached sample App for Applymap.

Please go through listed below link for Joins,

Kind regards,

Ishfaque Ahmed

jagan — Mon, 07 Mar 2016 04:00:58 GMT

Hi,

ApplyMap() is faster than Join. If we have more than two columns then we need to join both the tables, otherwise we can use ApplyMap().

So the first priority is ApplyMap()

Regards,

Jagan.

avinashelite — Mon, 07 Mar 2016 05:56:08 GMT

It depends on the data model, requirement and the amount of data that your handling .....

1.If your working with small data set than JOIN and apply map doesn't have much of the difference

2.If you want to map or recreate only few columns than mapping is better

3. If your using left or right joins than there are changes of losing the records but with apply map you will not lose any records