Rolling Sum

[Sameer225]

I need to know how to calculate the rolling sum in qlik sense script.

I below mention the example dataset that I am using and I need the rolling sum of the qty as new feild and the value shouldn't be changed when any filter is applied on the rolling sum 

[Channa · Accepted solution]

IF(Previous(Year)=Year,RangeSum(Peek(QTY),QTY),QTY) AS QTY