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.
So, without further ado, please watch this video
Elsewhere:
ApplyMap — Is it So Wrong? via QlikIntelligence
photo by: So 😉
