Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anku
Creator
Creator

Interesting Query: Order must deliver as per FIFO method

Hi all,

I have 2 data set, they don't have any PK.

1. Orders data:
These are the orders being placed by customer.

Anku_0-1656826210269.jpeg

2. ShopperStock:
Stock detail of each outlet

Anku_1-1656826252219.jpeg

 

Desired Outcome:
If multiple similar orders are in queue for a specific shop then it must deliver them according to the order placed, if not then it's an error/ red flag.
I have attached .qvf & excel for better understanding.

Please assist. Thank you.

 

Labels (1)
3 Replies
Anku
Creator
Creator
Author

 
MarcoWedel

Whats' your question?

Can you show what you already did that did not work?

Anku
Creator
Creator
Author

@MarcoWedel  apologies for delayed response.

Please refer attached qvf file. Further, In case you have a better way to do it, please do guide me.

Thanks