Opening and Closing Stock (Monthly)

[#1]

I have purchase qty for different dates.

i want to arrive at the opening and closing stock, but on a monthly basis.

i find many blogs on opening and closing using peek, but all these arrive at the values date wise.

i have attached an excel file with the inputs and desired output.

Can anyone help me understand how to write a script for this.

pls upload the answer as a qlikview file.

i am not an expert in scripts.

[swuehl · Accepted solution]

Maybe like attached.

[#3]

Dear Swuehl,

Thanks a ton for your help.

you are really great.

[vikasmahajan]

can you please give your expert comments on my requirement thread no

http://community.qlik.com/thread/91964

I have same type of requirement I want to display Month Wise Closing Stock But we have created stock by

using expressions we don't have opening and closing stored in table.

Thanks

Vikas

[srishsum2017]

Hi,

Please find the solution in qlisksense form

[vireshkolagimat]

Hi, Can you please help me to fix the issue in the below thread.

Opening and Closing stock from Oracle EBS

Thank you.