topic Re: Accumulation with two dimensions in QlikView

Accumulation with two dimensions

Dmichel0729 — Wed, 07 Apr 2021 17:14:35 GMT

Hello All,

I currently have a line chart that displays a count accumulation throughout the years. The two dimensions I am using are Year and Month. However, when I drill down to a specific year, the accumulation starts over in January (see below). Is there anyway to make the continue the accumulation when a specific year is selected?

Year Image:

Month Image (2020):

January for 2020 year selected should be close to the number 2499 in the first image.

The expression I am currently using is count(Date) with Full Accumulation checked.

Any help would be appreciated.

Thank you,

Dylan

Re: Accumulation with two dimensions

Dalton_Ruer — Tue, 13 Apr 2021 13:23:23 GMT

You could modify your expression to something logically like this. (Notice I said logically don't copy paste this code)

IF (GetSelectedCount(Year) and RowNo() = 1, Sum(Set analysis to accumulate previous years values) + my value, Your rangeabove expression currently being used)

Re: Accumulation with two dimensions

MayilVahanan — Wed, 14 Apr 2021 08:53:47 GMT

Hi @Dmichel0729

For ur scenario, you can use rolling n-period in scripting like below articles

https://community.qlik.com/t5/QlikView-Documents/Calculating-rolling-n-period-totals-averages-or-other/ta-p/1483033

https://community.qlik.com/t5/Qlik-Design-Blog/The-As-Of-Table/ba-p/1466130