Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
IF(Previous(Year)=Year,RangeSum(Peek(QTY),QTY),QTY) AS QTY