Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

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

Tags (1)
4 Replies
pavanthota
New Contributor III

Re: Apply Map

Hi,

Read the below link i hope it helps you

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

Cheers ,

Pavan

Employee
Employee

Re: Apply Map

Not applicable

Re: Apply Map

Hi,

Go through this link it's helpful ...

ApplyMap Function in Qlikview - YouTube

Thanks & Regards,

Harshal Patil

Not applicable

Re: Apply Map

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.

Community Browser