Accumulate amount by month per day

[#1]

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)

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:

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.

My result per day:

Thank you in advance,

Mornay

[#2]

Ok, this is what I am seeing now:

[#3]

Hi Sunny...

[sunny_talwar]

Is there any possibility to share you application with us?

[#5]

Hi Sunny,

Is there a specific data set that you will need, because I will not be allowed to share the data.. (Sorry).  Any other options available?

[#6]

Hello Guys... I hate to be nuisance, and appreciate all the replies so far.

This is what I have done so far...

1. Ordered the date in the select statement

2. Entered "RangeSum(Above(Total Sum(AmtCollected),0,RowNo(Total)),MONTHOF,DAYOF)"

3. Getting the following Graph output:

4. The January line started at about 180 000 and ended at an accumulated amount of 5 000 000.  The December line started at 1 200 000 and accumulated to +- 21 000 000.  this means that the two lines should have parted a lot..

See Excel example:

Thanks again for all your help so far

[#7]

Hello again..

I have added the following to my select statement:

Order by day(db_date) Asc

Once loaded with the previous expression:
"rangesum(aggr(rangesum(above(sum(AmtCollected),0,RowNo())),MONTHOF,DAYOF))"

I finally got the desired result

Thank you very much for all your help guys... it is working so far.!