straight table cumulative sum

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

I want to do a cumulative sum with previous row data

I have 2 columns Sellout and Sellin and a Stock fixed at some value, here i took as 5.

since for the first row it has to take the stock value

I need to calculate inventory Projection(InvProj) as Previous Row value of Inventory Projection(InvProj)+Sellout-Sellin

Note Sellin and Sellout are from current row.

I have done the below, but when i select month it is taking it as the first row and expression is giving correct numers

I used the below calculation,

if(Rowno()=1,vstock+sum(Sellout)-sum(Sellin),rangesum(above(InvProj)+sum(Sellout)-sum(Sellin),0))

Please let me know where i went wrong..Please find the attached qlikview document.

Thanks,

Shravan

Re: straight table cumulative sum

sunny_talwar — Wed, 22 Nov 2017 17:08:28 GMT

Try this

(vstock+RangeSum(Above(Sum({<Month>}Sellout)-Sum({<Month>}Sellin), 0, RowNo()))) * Avg(1)

Anonymous — Wed, 22 Nov 2017 19:00:15 GMT

Thank you Sunny, That worked.

sunny_talwar — Wed, 22 Nov 2017 19:56:37 GMT

Awesome, please close the thread in that case.

Best,

Sunny