topic What is Mapping Statement in qlikview? in QlikView

What is Mapping Statement in qlikview?

arethaking — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

I am new for Qlikview,

please help with examples.

Thank you All.

Re: What is Mapping Statement in qlikview?

kaushiknsolanki — Fri, 03 Aug 2018 05:28:24 GMT

HI,

Check this link.

https://help.qlik.com/en-US/qlikview/November2017/Subsystems/Client/Content/Scripting/MappingFunctions/mapping-functions…

What is a Mapping Load in Qlikview

Regards,

Kaushik Solanki

Re: What is Mapping Statement in qlikview?

qlikviewwizard — Fri, 03 Aug 2018 05:56:52 GMT

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?