Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
markgraham123
Specialist
Specialist

Peek Help with script

Hello Everyone,

I'm tring to create a logic with the below sample data:

Req O/P: 'Can fill' column

   

ITEMIncoming DateIncoming_Qty  RequiredCan fill
110/19/201781    12681
111/1/2017122   45
111/1/2017214
111/9/2017233

I have 126 units required.

i'm getting 81 on one date. So, i can fill only 81 units.

Now, the rem. quantity is 45. This can be filled with the incoming qty on 11/1/2017.

Please see attached application.

Any help is highly appreciated.

0 Replies