Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Hi !
Did you find the solution ?
i'm really interested