topic Re: Re: apply map in QlikView

apply map

arulsettu — Wed, 01 Oct 2014 07:11:42 GMT

i want to add this InvoiceQty and QtyOrdered by using apply map function

so i tried here

InvoiceQty:

Mapping LOAD ItemNumber,

InvoiceQty

Resident Invoice;

test1:

LOAD ItemNumber,

ApplyMap('InvoiceQty',QtyOrdered) as newqty

Resident Orders;

but the result is it only showing QtyOrdered data.

what am i doing wrong any suggestions?

Re: apply map

amit_saini — Wed, 01 Oct 2014 07:14:26 GMT

Hope this will help you:

Thanks,
AS

Re: apply map

tresB — Wed, 01 Oct 2014 07:16:22 GMT

Perhaps, like this:

LOAD ItemNumber,

ApplyMap('InvoiceQty', ItemNumber) as newqty

Resident Orders;

Re: apply map

arulsettu — Wed, 01 Oct 2014 07:16:30 GMT

sorry amit using personal edition can tell whats wrong with the above code

thanks

Re: apply map

Wed, 01 Oct 2014 07:19:36 GMT

Use ItemNumber instead of QtyOrdered in ApplyMap function..

Re: apply map

amit_saini — Wed, 01 Oct 2014 07:20:53 GMT

Arul,

'ItemNumber' should be here instead of 'QtyOrdered' here in below script:

ApplyMap('InvoiceQty',QtyOrdered) as newqty

Thanks,

Re: apply map

amit_saini — Wed, 01 Oct 2014 07:24:58 GMT

To understand the concept please see below:

Script:

Purchase:

LOAD * Inline [

PurchaseID,Product,PurchasePrice,Quantity,PurchaseDate

P9, Product1, 8, 20, 15/10/2010

P11, Product1, 7, 10, 09/10/2010

P12, Product1, 9, 20, 01/10/2010

];

Temp:

Mapping LOAD

Product,PurchasePrice

Resident Purchase;

DROP Table Purchase;

Sales:

LOAD ApplyMap('Temp', Product ) as PurchasePrice,* Inline [

SalesID,Product,SalesPrice,Quantity,SalesDate

S1, Product1, 10, 10, 10/10/2010

];

Output:

Thanks,
AS

Re: apply map

aveeeeeee7en — Wed, 01 Oct 2014 07:25:39 GMT

Use ItemNumber which is the Primary Key between 2 Tables:

Change your Code. See below:

InvoiceQty:

Mapping LOAD ItemNumber,

InvoiceQty

Resident Invoice;

test1:

LOAD ItemNumber,

ApplyMap('InvoiceQty',ItemNumber) as newqty

Resident Orders;

Regards

Av7eN

Re: apply map

arulsettu — Wed, 01 Oct 2014 07:32:41 GMT

like this

ApplyMap('InvoiceQty',ItemNumber) as newqty

but it giving same result

Re: apply map

ashfaq_haseeb — Wed, 01 Oct 2014 07:38:30 GMT

Post your sample application to have a look.

Or try by changing your code like this

InvoiceMAP:

Mapping LOAD ItemNumber,

InvoiceQty

Resident Invoice;

test1:

LOAD ItemNumber,

ApplyMap('InvoiceMAP',ItemNumber) as newqty

Resident Orders;

Regards

ASHFAQ

Re: Re: apply map

arulsettu — Wed, 01 Oct 2014 07:57:55 GMT

here it is

Re: apply map

ashfaq_haseeb — Wed, 01 Oct 2014 08:16:48 GMT

Its corrupted I believe,

Can you attach it again

Regards

ASHFAQ

Re: Re: apply map

arulsettu — Wed, 01 Oct 2014 08:34:25 GMT

Re: apply map

ashfaq_haseeb — Wed, 01 Oct 2014 08:50:03 GMT

What I see is you have multiple quantities for one ItemID.

By default applymap will take first value.

Have a look at below post for further clarification

http://community.qlik.com/message/534391#534391

Regards

ASHFAQ

Re: apply map

Wed, 01 Oct 2014 18:16:59 GMT

Thanks