Accumulation In Qlik Sense

[munna1317]

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

[Gysbert_Wassenaar]

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

[#3]

Hi !

Did you find the solution ?

i'm really interested