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:

Related Posts Plugin for WordPress, Blogger...