Rolling Balance

jli87 — Wed, 10 Oct 2018 21:17:48 GMT

Header 1	Header 2	Header 3	Header 4	Header 5
Product	Date	Order Qty	Begin Inventory	Adjusted Inventory
Apple	10/08/18	20	500	60
Apple	10/15/18	30		45
Apple	10/22/18	5		30
Orange	10/08/18	25	600	35
Orange	10/15/18	15		40
Banana	10/08/18	35	650	25
Banana	10/15/18	60		20

I am having issues with creating a table with beginning inventory for each week. I have a table similar to the one above with only a specific week with a beginning inventory. I need to factor in the order qty and adjusted inventory for each week to get the beginning inventory for the next week like something on the bottom. Thank you in advance.

Header 1	Header 2	Header 3	Header 4	Header 5
Product	Date	Order Qty	Begin Inventory	Adjusted Inventory
Apple	10/08/18	20	500	60
Apple	10/15/18	30	540	45
Apple	10/22/18	5	555	30
Orange	10/08/18	25	600	35
Orange	10/15/18	15	610	40
Banana	10/08/18	35	650	25
Banana	10/15/18	60	640	20

Re: Rolling Balance

uacg0009 — Thu, 11 Oct 2018 06:09:11 GMT

Hi Jia Li,

I think below is what you want, please see the attachment, thanks.

Aiolos Zhao

Re: Rolling Balance

jli87 — Thu, 11 Oct 2018 13:51:14 GMT

Yes, that's how I want it to look but can this be done from the script end?

Re: Rolling Balance

uacg0009 — Fri, 12 Oct 2018 02:07:15 GMT

Yes,you can try to use peek() function to change the above() function in back-end.

the sort is important.

Aiolos

topic Re: Rolling Balance in QlikView

Rolling Balance

Re: Rolling Balance

Re: Rolling Balance

Re: Rolling Balance