topic Re: ApplyMap Function Use and Where Should we Use This Function? in QlikView

ApplyMap Function Use and Where Should we Use This Function?

khasimvali85 — Thu, 12 Jun 2014 10:08:49 GMT

Hi,

About ApplyMap() Can Anybody Explain brief with Example?

Thanks

Khasim

Re: ApplyMap Function Use and Where Should we Use This Function?

Anonymous — Thu, 12 Jun 2014 10:11:25 GMT

Check this link

Apply Map Concept

Re: ApplyMap Function Use and Where Should we Use This Function?

hic — Thu, 12 Jun 2014 10:11:31 GMT

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

Re: ApplyMap Function Use and Where Should we Use This Function?

vijetas42 — Thu, 12 Jun 2014 10:24:10 GMT

Hi,

ApplyMap is a Mapping or lookup function

Ex. one of my scenario where I have applied ApplyMap is,

For missing Employee name we have to use lookup function (ApplyMap) to get data from excel .At the time of showing Employee code and Employee name, from sap source table we have, Employee code Employee name that is but for some of the Employee code, Employee name is missing and there is excel file in which they are having Employee code and name so, we have used ApplyMap and checked that if any Employee name is missing then apply lookup on excel for respective Employee code and get that Employee name.

Hope this will help you to understand ApplyMap concept and where it should be applied!!!

Regards,

Vijeta

Re: ApplyMap Function Use and Where Should we Use This Function?

ngulliver — Thu, 12 Jun 2014 10:28:37 GMT

Hi,

As well as Henric's excellent blog there is also one by Steve Dark that is worth looking at:

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

Regards,

Neil

Re: ApplyMap Function Use and Where Should we Use This Function?

Thu, 12 Jun 2014 10:31:52 GMT

Hi,

It works similar to Vlookup in Excel. Only Difference is we need to create Mapping table to fetch the relevant data. Mapping table always contains 2 columns, first column is the reference and second column is the data which you want to extract, only drawback is from one mapping table you can extract only one column, cannot fetch multiple columns from single mapping table....

Regards,

Savitha

Re: ApplyMap Function Use and Where Should we Use This Function?

khasimvali85 — Thu, 12 Jun 2014 10:39:06 GMT

Hi Savitha,

Thanks for Information

i under stood the concept but how to apply in Script? give me two or more examples.

Thanks

Khasim.

Re: ApplyMap Function Use and Where Should we Use This Function?

khasimvali85 — Thu, 12 Jun 2014 10:39:42 GMT

Hi Sharma,

Thanks for Information

i under stood the concept but how to apply in Script? give me two or more examples.

Thanks

Khasim.

Re: ApplyMap Function Use and Where Should we Use This Function?

vijetas42 — Thu, 12 Jun 2014 10:54:02 GMT

Hi,

Check this example,Hope you will understand

TEMP:

Mapping Load * Inline

[

id2, pg1

1, abc

2, mno

3, tuv

4, xyz

];

T1:

Load * Inline

[

id1, id2, value

A, 1, 100

B, 2, 120

C, 3, 140

]Where Match(id1,'A','B');

Left Join

Load * Inline

[

id1, pg1

A, pqr

D, xyz

E, 123

];

NoConcatenate

FINAL:

Load id1, id2, value, IF(pg1='',ApplyMap('TEMP',id2),pg1) as pg1 Resident T1;

Drop Table T1;

Regards,

Vijeta