16 Replies Latest reply: Feb 8, 2016 9:08 AM by Mornay Botha RSS

    Accumulate amount by month per day

    Mornay Botha

      Hello Community,

      First time here...

      Please be so kind as to point me in the right direction with regards to the following:

      We have just installed Qlik Sense on our servers. (going for 2nd week)

       

      I am trying to display a chart in Qlik Sense so that it displays the same or similar way that it is currently displaying on my excel spreadsheet below:  (Accumulated amount per month per day)

       

      chart.PNG

       

      I have tried the below suggestions found on several forums, but none of these worked.

       

      // rangesum( above( sum(AmtCollected),0,RowNo()))

      // rangesum( above( sum(AmtCollected),0,RowNo()))

      // sum( aggr( rangesum( above( sum(AmtCollected),0,12) ),Month))

      // RangeSum(Above(Total sum(AmtCollected),0,RowNo()))

      // sum(AmtCollected)

       

      The fields that I am currently using are as follow:

      chart_dimensions_and_measure.PNG

      Any idea on what I am doing wrong?

       

      My result does not accumulate the values per day.  If I remove a dimension day, i.e to display per month, it does accumulate per month.

      accumulate.PNG

       

      My result per day:

      perdayaccumulate.PNG

       

      Thank you in advance,

      Mornay