Accumulation in Qlikview Scripting

[#1]

Hi Team

How can we go for cumulative Sum in Script itself

Requirement:

We have 3-4 Dimensions available - Year, Month, Name, Address

KPI - Salary

For Name, Address combination, Salary should get added up for YearMonth Combination.

We are trying to achieve it using for loops in the script but it's leading to huge reload time of the qvw file.

Can anyone suggest something helpful here?

Thanks

Rashmi

[maxgro · Accepted solution]

You can resident load your table order by Name, Address, Year, Month adding a new field, cum Salary.

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