Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
here it is
Its corrupted I believe,
Can you attach it again
Regards
ASHFAQ
ok
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
Thanks