Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Ok, this is what I am seeing now:
Hi Sunny...
Is there any possibility to share you application with us?
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?
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
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.!