Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On Demand Webinar: See Why Thousands of QlikView Users Have Switched to Qlik Sense. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
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
maxgro
MVP
MVP

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

View solution in original post

1 Reply
maxgro
MVP
MVP

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

View solution in original post