topic Re: Cumulative Net Stock Calculation in QlikView

Cumulative Net Stock Calculation

khan_imran — Mon, 19 Mar 2018 14:48:00 GMT

Hello All,

Thanks for all your support for previous responses.

I am trying to find cumulative Net Stock value using the below formula.

Formula	Delivered+(Closing-Opening)
Delivered	Sum(Delivered for the whole year)
Closing	sum(Closing for the whole year)
Opening	It will remain constant for all months i.e. March'17 value

In the calculation, my opening stock balance will remain constant for all the month. Lets Assume, I am in the month of January'18 & want to see the data YTD December'17. Here;

Delivered = 99(cumulative value)

Closing = 606

Opening = 100

Net Stock = Delivered + (Closing - Opening)

hence Net Stock = 99+(606-100)

Therefore Net Stock = 605.

Similar to above example, I want to apply the same approach to each month.

Attached is the sample with formula & output looking at.

Kindly assist with the same.

Re: Cumulative Net Stock Calculation

YoussefBelloum — Mon, 19 Mar 2018 22:20:21 GMT

Hi,

would you be able to describe the expected output ?

Re: Cumulative Net Stock Calculation

khan_imran — Tue, 20 Mar 2018 04:33:13 GMT

Expected output is already there in the attached excel.

Re: Cumulative Net Stock Calculation

kakani87 — Tue, 20 Mar 2018 11:53:55 GMT

Something like this ?

Re: Cumulative Net Stock Calculation

khan_imran — Tue, 20 Mar 2018 12:18:53 GMT

The output must be as mentioned below;

Month	Apr'17	May'17	Jun'17	Jul'17	Aug'17	Sep'17	Aug'17	Sep'17	Oct'17	Nov'17	Dec'17
Toy	50	101	153	206	260	315	371	428	486	545	605

Re: Cumulative Net Stock Calculation

kakani87 — Tue, 20 Mar 2018 12:32:58 GMT

Like this?