topic Accumulation in Qlikview Scripting in QlikView https://community.qlik.com/t5/QlikView/Accumulation-in-Qlikview-Scripting/m-p/1107026#M897834 <HTML><HEAD></HEAD><BODY><P>Hi Team</P><P></P><P>How can we go for cumulative Sum in Script itself</P><P>Requirement:</P><P>We have 3-4 Dimensions available - Year, Month, Name, Address</P><P>KPI - Salary</P><P>For Name, Address combination, Salary should get added up for YearMonth Combination.</P><P></P><P>We are trying to achieve it using for loops in the script but it's leading to huge reload time of the qvw file.</P><P></P><P>Can anyone suggest something helpful here?</P><P></P><P>Thanks</P><P>Rashmi</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT 2020-11-25T16:16:04Z Accumulation in Qlikview Scripting https://community.qlik.com/t5/QlikView/Accumulation-in-Qlikview-Scripting/m-p/1107026#M897834 <HTML><HEAD></HEAD><BODY><P>Hi Team</P><P></P><P>How can we go for cumulative Sum in Script itself</P><P>Requirement:</P><P>We have 3-4 Dimensions available - Year, Month, Name, Address</P><P>KPI - Salary</P><P>For Name, Address combination, Salary should get added up for YearMonth Combination.</P><P></P><P>We are trying to achieve it using for loops in the script but it's leading to huge reload time of the qvw file.</P><P></P><P>Can anyone suggest something helpful here?</P><P></P><P>Thanks</P><P>Rashmi</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Accumulation-in-Qlikview-Scripting/m-p/1107026#M897834 2020-11-25T16:16:04Z Re: Accumulation in Qlikview Scripting https://community.qlik.com/t5/QlikView/Accumulation-in-Qlikview-Scripting/m-p/1107027#M897835 <HTML><HEAD></HEAD><BODY><P>You can resident load your table order by Name, Address, Year, Month adding a new field, cum Salary.</P><P>Using peek function (or previous), when Name or Address change, set cum Salary to current row Salary, else add current row Salary to previous row cum Salary </P></BODY></HTML> Tue, 02 Aug 2016 07:08:14 GMT https://community.qlik.com/t5/QlikView/Accumulation-in-Qlikview-Scripting/m-p/1107027#M897835 maxgro 2016-08-02T07:08:14Z