Order vs Deliveries vs Pending with Back date query

Tue, 27 Jan 2015 17:47:58 GMT

Hi,

I have a table Orders which contains the Orders and it's lines with QTY, I have separate table Invoices which contains the order reference delivery date and delivered qty. For 1 order line there are multiple deliveries of partial order qty.Problem I am facing is when i load with reference to both the tables than as soon as i select the delivery date order qty is limited to the orders that are referenced via those delivery dates.

I want to show the total Order QTY with Order date selection separately and in front the delivered qty to be shown based on the delivery date selection

Help will be highly appreciated or point towards relevant posts thanks.

Re: Order vs Deliveries vs Pending with Back date query

maxgro — Tue, 27 Jan 2015 20:10:57 GMT

if I understand

Sum({$<OrderLink=P(OrderLink),[INV Date]=>} InvQty)

Re: Order vs Deliveries vs Pending with Back date query

Wed, 28 Jan 2015 06:06:06 GMT

Thanks Massimo for prompt response, let me try to illustrate the requirement below

topic Order vs Deliveries vs Pending with Back date query in QlikView

Order vs Deliveries vs Pending with Back date query

Re: Order vs Deliveries vs Pending with Back date query

Re: Order vs Deliveries vs Pending with Back date query