Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

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

Accumulation In Qlik Sense

Hello Team ,

In Qlikview we have Full Accumulation Option . But in Qlik Sense we dont have .

For single Dimension We can use

rangesum( above( sum([Expression1]),0,rowno()))


But if we have 2 Dimension in Place . How to get Accumulation .


I have tried in This way


=Max( Aggr( rangesum( above( Sum(Aggr(sum({<No = {10}>} Expression),Filed-1,Field-2)),0,RowNo())),

Filed-1,Field-2))

But it not Working . There is any better way to Get Full Accumulation .

Thanks In Advance ,

Harish

2 Replies
MVP & Luminary
MVP & Luminary

Re: Accumulation In Qlik Sense

Perhaps like this: rangesum( above(total sum([Expression1]),0,rowno(total)))

If not you can try using an AsOf kind of table: The As-Of Table


talk is cheap, supply exceeds demand
Not applicable

Re: Accumulation In Qlik Sense

Hi !

Did you find the solution ?

i'm really interested