
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Accumulative Line Graph Daily/Monthly Comparison
Hi All,
Similar to this graph in QlikView where I simply enable 'Full Accumulation' I am looking to accumulate Daily Sales for the last 6 months in Qlik Sense and I'm struggling a bit.
Expression is
sum({$<year=, month=,day=, yearmonthnum = {">$(=Date(Addmonths(Date#(max(yearmonthnum),'YYYYMM'),-6),'YYYYMM'))<=$(=Date(Addmonths(Date#(max(yearmonthnum),'YYYYMM'),0),'YYYYMM'))"}>}Sales)
Dimensions would be day and yearmonthnum
I've tried using Rangesum(above()) but I can't work out the aggregation on the correct level.
Any help would be appreciated.
Thanks
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
@otherguy
Qlik Sense also contains the accumulation modifier alongside the expression, please confirm in your version.
- Matheus

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Instead of using the "yearmonthnum" as the operative modifier in Set Analysis I suggest you use a default formatted date field so your Set analysis would look like this...
sum({$<year=, month=,day=, yearmonthnum =, thedetaildate = {"$(='>' & Addmonths(max(thedetaildate),-6) & '<=' & Date(max(thedetaildate)))"}>}Sales)
// the expression should evaluate as follows if the mas date is today
//sum({$<year=, month=,day=, yearmonthnum =, thedetaildate = {">1/8/2024<=7/8/2024"}>}Sales)

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
@otherguy
Qlik Sense also contains the accumulation modifier alongside the expression, please confirm in your version.
- Matheus

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thanks Matheus, missed that.. Although, the accumulation doesn't seem to work with one measure and multiple dimensions, I had to create an expression for each month dating back with Day as the Dimension with the accumulation for each expression enabled.
Thank you
