Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
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
MVP
MVP

Re: how to use Cumulative sum in with Aggr()

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
MVP
MVP

Re: how to use Cumulative sum in with Aggr()

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

Re: how to use Cumulative sum in with Aggr()

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?