topic Re: Accumulative Line Graph Daily/Monthly Comparison in App Development

Accumulative Line Graph Daily/Monthly Comparison

otherguy — Mon, 08 Jul 2024 15:02:08 GMT

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

Re: Accumulative Line Graph Daily/Monthly Comparison

chriscammers — Mon, 08 Jul 2024 15:34:30 GMT

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)

Re: Accumulative Line Graph Daily/Monthly Comparison

MatheusC — Mon, 08 Jul 2024 18:30:46 GMT

@otherguy

Qlik Sense also contains the accumulation modifier alongside the expression, please confirm in your version.

- Matheus

Re: Accumulative Line Graph Daily/Monthly Comparison

otherguy — Tue, 09 Jul 2024 06:17:32 GMT

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