What is Mapping Statement in qlikview?

[arethaking]

Hi All,

I am new for Qlikview,

please help with examples.

Thank you All.

[kaushiknsolanki]

HI,

Check this link.

https://help.qlik.com/en-US/qlikview/November2017/Subsystems/Client/Content/Scripting/MappingFunctio...

What is a Mapping Load in Qlikview

Regards,

Kaushik Solanki

[qlikviewwizard · Accepted solution]

Please check this simple example.

//Mapping Table

CustomerTable:
Mapping Load * Inline
[
CustomerID, Country
A, Germany
B, France
C, Italy
D, Poland
E, Spain
Z, UK
];

Sales:
Load *,
ApplyMap('CustomerTable', CustomerID, 'Unknown') as CustomerCountry

Inline
[
CustomerID, Month, Sales
A, Jan, 100
B, Jan, 200
C, Jan, 300
D, Feb, 150
E, Mar, 200
F, Apr, 100
A, May, 140
D, May, 80
E, May, 100
F, Jun, 150
];

Credit : Anand Chouhan

what is mapping load and apply map?