ApplyMap Function

Mapping is a familiar concept to those of you who have dealt with ETL(Extract, Transform and Load).

ApplyMap is a lookup or mapping function in Qlikview. In nutshell, it is a simple little function in Qlikview that you can get addicted with easily once you master it and keep finding creative ways to use it in your Qlikview applications.

With that said, I thought of first giving you a 10,000 feet overview of the function so that you get thoroughly grounded with it.

In subsequent videos, I will dive into some fun and creative ways you can use this macho function in your app.

This function allows you to lookup a value from a lookup table and fetch the retrieved value into another table.

You need to know some key aspects of this function.

  • Lookup table can only have two columns
  • The first field in the lookup table must be a key field.
  • The table name in the applymap function has to be inside single quotes.
  • Third parameter in the applymap function is optional, but it allows you to use nested applymap function to perform additional mappings when match is not found between two tables.

ApplyMap Function in Qlikview

So, without further ado, please watch this video

 

Elsewhere:

ApplyMap — Is it So Wrong? via QlikIntelligence

photo by: So 😉


If you enjoyed this article, get email updates (it’s free).

Email Address:

  • A Qlikview Tutorial: Mapping Load in Qlikview « Learn Qlikview 5:02 pm on May 12, 2013 Permalink

    […] ApplyMap Function in Qlikview May 7, 2013 […]

  • thiago 5:44 pm on November 21, 2013 Permalink

    I have a table with fields that return values ​​as 1,2,3,4,5,6,7, and I need to group the values ​​1,2,3 as’ new name ‘and 4,5,6 and 7 with’ other name ‘, as I do?

    Thiago

  • Sergey 12:46 pm on August 31, 2016 Permalink

    I found error in your explanation: ‘Mapping Table Name’ should be “Customer_Map” (NOT Tbl_Customer)