2 Replies Latest reply: Jun 21, 2017 1:34 PM by Dave Melillo RSS

    Full Accumulation in QlikSense

    Dave Melillo

      Goal is to sum subscription dollars over time to see how individual companies are growing within our ecosystem over time.

       

      I am using QlikSense. I know there is not a Full Accumulation button in QlikSense so I have been using the following expression.

       

      = rangesum(above(Sum({<[Opps.IsWon] = {'1'}>}[Opps.ARR_equivalent__c]),0,rowno()))

       

      However it is not working as expected. If you see the graph below it is just summing the subscription amounts per subscription start date (x axis) ... Any help is appreciated!!!

       

      QLIK06212017.PNG