topic Mapping Load in QlikView

Mapping Load

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

Hey community,

i have this script and i write "A, Jan, 100" twice i try to understand if i can see both of the line together at table view.

the only way i can see the total of them is at Pivot table.

but i want to see germany jan twice

Thx

CustomerTable:

Mapping Load * Inline

[

CustomerID, Country

A, Germany

B, France

C, Italy

D, Poland

E, Spain

Z, UK

H, ISRAEL

A, Germany ];

Sales:

Load *,

ApplyMap('CustomerTable', CustomerID, 'Unkown Country ') 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

Z, Apr, 100

];

Re: Mapping Load

sunny_talwar — Mon, 28 Mar 2016 15:03:27 GMT

May be add a new field using RowNo() which makes both instances of Jan unique:

CustomerTable:

Mapping Load * Inline

[

CustomerID, Country

A, Germany

B, France

C, Italy

D, Poland

E, Spain

Z, UK

H, ISRAEL

A, Germany ];

Sales:

Load *,

RowNo() as SNo,

ApplyMap('CustomerTable', CustomerID, 'Unkown Country ') 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

Z, Apr, 100

];

Re: Mapping Load

Anonymous — Mon, 28 Mar 2016 15:06:42 GMT

Have you tried a Straight Table, as opposed to a Pivot Table ?

Re: Mapping Load

veidlburkhard — Mon, 28 Mar 2016 15:38:15 GMT

Hi David,

the best way will be to use Sunny's idea and put it into a straight table in UI:

Hope this helps

Burkhard

Re: Mapping Load

Anonymous — Tue, 29 Mar 2016 05:00:22 GMT

Hey @bill.markham yes i did its show me the result on the pivot table also i try to see the result on the regular table.