Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

how to use Cumulative sum in with Aggr()

Dear Team,

i want to create a temp table using aggr() method but the Expression should me cumulative sum().

i used below method rangesum(Above(sum({<MEMBER>} TURNOVER),1,rowno())) what we mostly do in table.

i have tried same to within Aggr() function but did not work..

Aggr(rangesum(Above(sum({<MEMBER>} TURNOVER),1,rowno())),CITY,MEMBER)

can any one help me in this

1 Solution

Accepted Solutions
MK_QSL
MVP
MVP

Copied from Pareto Analysis written by HENRIC

No, unfortunately this is today not possible. But we are looking at possibilities to do this in future versions. Basically, you would need an Aggr() function with a sorted output vector. And today Aggr() cannot be sorted.

View solution in original post

2 Replies
MK_QSL
MVP
MVP

Copied from Pareto Analysis written by HENRIC

No, unfortunately this is today not possible. But we are looking at possibilities to do this in future versions. Basically, you would need an Aggr() function with a sorted output vector. And today Aggr() cannot be sorted.

sunny_talwar

If I am thinking it right, you may need to have RangeSum Above outside the Aggr function. Do you have a sample that you can share?