topic Re: Calculate data from previous rows in script in QlikView

Calculate data from previous rows in script

Fri, 30 Oct 2015 06:35:22 GMT

Hi to everyone!

I have a db table like:

Yellow cells is have to be calculated.

ToBuy = Ordered - Remain

Remain = Remain (in previous month) - Ordered (in previous month) + ToBuy (in previous month)

So, the result should be like:

Please, help to make it in load script or give please a hint to find the solution. Thanks!

P.S. I tried to make it in expression, but I couldn't do it in pivot table where I put in columns "Month-Year".

Thanks!

Re: Calculate data from previous rows in script

Sun, 01 Nov 2015 15:08:52 GMT

I think the only way is to make Looping.

But I don't know how to make it in right way. Please help!

Re: Calculate data from previous rows in script

marcus_sommer — Sun, 01 Nov 2015 19:28:42 GMT

You could use previous() or peek() to catch the values from the previous records - a very good explanation could you find here: Peek() or Previous() ? and in your case, something like:

previous(Remain) - previous(Ordered) + previous(ToBuy)

- Marcus