topic Re: apply map for fact details in QlikView

apply map for fact details

chaitanyajami — Tue, 01 Dec 2015 11:25:19 GMT

hi,

actually i have order id,soap id,number of items sold ,year wise in ORDER table and soap id,cost in SOAP DETAILS table , now i want to derive a new field for number of items sold * cost, i have used apply map to get cost column into my fact table(ORDER) but the multiplication is not working please help

MapOrdertoSoap:

mapping Load

[SOAP ID],

COST

from

(ooxml, embedded labels, table is [SOAP DETAILS]);

ORDERS:

LOAD ID as orderid,

[SOAP ID],

[CITY ID],

[NO OF ITEMS SOLD],

[SALE YEAR],

ApplyMap('MapOrdertoSoap','[SOAP ID]','NO DATA') as COST,

[NO OF ITEMS SOLD] * COST as [ORDER AMOUNT]

FROM

(ooxml, embedded labels, header is 2 lines, table is ORDERS);

Re: apply map for fact details

sunny_talwar — Tue, 01 Dec 2015 16:30:40 GMT

[SOAP ID] doesn't need single quotes around it and you would need to put the ORDER AMOUNT calculation in a preceding load. Try this:

MapOrdertoSoap:

mapping Load

[SOAP ID],

COST

from

(ooxml, embedded labels, table is [SOAP DETAILS]);

ORDERS:

LOAD *,

[NO OF ITEMS SOLD] * COST as [ORDER AMOUNT];

LOAD ID as orderid,

[SOAP ID],

[CITY ID],

[NO OF ITEMS SOLD],

[SALE YEAR],

ApplyMap('MapOrdertoSoap', [SOAP ID],'NO DATA') as COST

FROM

(ooxml, embedded labels, header is 2 lines, table is ORDERS);

Re: apply map for fact details

chaitanyajami — Tue, 01 Dec 2015 16:40:56 GMT

Hi Sunny,

Thanks a lot, its working fine.

Re: apply map for fact details

sunny_talwar — Tue, 01 Dec 2015 18:01:26 GMT

Awesome