topic Re: Applymap in QlikView

Applymap

Wed, 23 Apr 2014 09:02:37 GMT

Hi every one,

I want to know about usage of applymap and what is the relation between applymap and mapping load?

When we go for applymap and why we are using mapping load?

Please help me in this if anyone knows.

Re: Applymap

ashfaq_haseeb — Wed, 23 Apr 2014 09:04:23 GMT

Hi,

Please refer the below post from henric.

http://community.qlik.com/blogs/qlikviewdesignblog/2012/09/18/one-favorite-function-applymap

Hope it help.

Regards

ASHFAQ

Re: Applymap

MK_QSL — Wed, 23 Apr 2014 09:08:42 GMT

ApplyMap function is used to lookup and find value from one table to other.

ApplyMap table need to be load using Mapping Load......

There should be only two field... 1st for lookup and 2nd for result...

There should not be any duplicate values in Mappling Load Table.

Mapping Load is to Load Table and ApplyMap is to get the values from Mapping Load Table..

End of the scrip

Example given below...

Consider that you have Customer and Country in one table and Sales in another table.

You want Country in Sales Table... Write below in script...

CustomerTable:

Mapping Load * Inline

[

Customer, Country

A, Germany

B, France

C, Italy

D, Poland

E, Spain

Z, UK

];

Sales:

Load *,

ApplyMap('CustomerTable', CustomerID, 'Unknown') as CustomerCountry

Inline

[

CustomerID, Month, Sales

A, Jan, 100

B, Jan, 200

C, Jan, 300

D, Feb, 150

E, Mar, 200

F, Apr, 100

A, May, 140

D, May, 80

E, May, 100

F, Jun, 150

];

Re: Applymap

ngulliver — Thu, 24 Apr 2014 08:12:14 GMT

Hi, Sattish.

It is certainly worth learning how to use an ApplyMap as they are incredibly useful

Have a look at this blog explaining ApplyMap.

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

Regards,

Neil