2 Replies Latest reply: Apr 21, 2017 11:53 AM by Bruno Charvin RSS

    Accumulation In Qlik Sense

    A Harish

      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