Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

markgraham123
Contributor II

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.