Why we are using the apply map in qlikview.

[#1]

hi to everybody,

i didnt understand of apply map.canyou plz explain in detail.

cheers

Hita

[#2]

Hi Hita,

Have a look a few examples such as the below, they should help your understanding of applymap

http://community.qlik.com/docs/DOC-7414

http://community.qlik.com/docs/DOC-5791

hope that helps

Joe

[ashfaq_haseeb]

Hi,

Check this

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

Regards

ASHFAQ

[its_anandrjs]

Hi,

Mapping table is used where we have two fields in the mapping table and on the basis of the ID or any key fields we do apply map to the table for more see this example.

In MapTab there is Id and Description is available but this desc info is not in the fact table then we use the mapping table

MapTab:
Mapping LOAD * Inline
[
ID,Desc
1,Desc1
2,Desc2
3,Desc3
4,Desc4
];

Fact:
LOAD ApplyMap('MapTab',ID) as Desc ,* Inline
[
ID,Sales,Location
1,48741,L1
2,12369,L2
3,14852,L3
];

after this you get four fields on the basis of the ID field

Regards

Anand

[jpenuliar]

Kinda excel vlookup(in 2 columns) equivalent to Qlikview.

[jpenuliar]

you have the Mapping load part which is your vlookup Table_Array