apply map

[arulsettu]

hi

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?

[arulsettu]

here it is

[ashfaq_haseeb]

Its corrupted I believe,

Can you attach it again

Regards

ASHFAQ

[arulsettu]

ok

[ashfaq_haseeb · Accepted solution]

Hi

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

[#6]

Thanks