Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Dmichel0729
Contributor
Contributor

Accumulation with two dimensions

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:

Dmichel0729_0-1617815536608.png

Month Image (2020):

Dmichel0729_1-1617815577478.png

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 

 

1 Reply
Dalton_Ruer
Employee
Employee

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)