Discussion board where members can get started with QlikView.
How can we go for cumulative Sum in Script itself
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?
Go to 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