Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Highlighted
Not applicable

Accumulation in Qlikview Scripting

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

1 Solution

Accepted Solutions
MVP
MVP

Re: Accumulation in Qlikview Scripting

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

1 Reply
MVP
MVP

Re: Accumulation in Qlikview Scripting

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