Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
Not applicable

Order vs Deliveries vs Pending with Back date query

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.

MJ

2 Replies
MVP
MVP

Re: Order vs Deliveries vs Pending with Back date query

if I understand

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

Not applicable

Re: Order vs Deliveries vs Pending with Back date query

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

Raising Questions.jpg