Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Apply Map

I am new to QlikView. I heard about Apply Map function a lot much. Can anyone help me in telling what is Apply map . If possible also please provide a document or page relating to Apply Map

4 Replies
pavanthota
Creator
Creator

Hi,

Read the below link i hope it helps you

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

Cheers ,

Pavan

hic
Former Employee
Former Employee

Not applicable
Author

Hi,

Go through this link it's helpful ...

ApplyMap Function in Qlikview - YouTube

Thanks & Regards,

Harshal Patil

Not applicable
Author

Hi Manish,

In simple terms, Applymap works is a lot like a vlookup in Excel, but in two stages. First you use mapping load to load the table with an identifier column and the labels. Then, in your destination table, you call the function applymap so it returns the label based on a field you have in that table, like this:

applymap('name of the mapping table',Field with values to identifier column,value if no match is found) // qlikview help has more detail

A left join can also be used instead, and it's almost identical. But be aware that a left join will create duplicates if the data you want to join isn't unique. Applymap is good here because it just links one value.