Cumulative count until YEAR-1 (Previous Year)

[yassine1992]

Hello

In Fact, there is a solution in the blog for cumulative count per months :

Max(Aggr(RangeSum(Above(Count({<Active_Month, Active_Date>}DISTINCT AccID), 0, RowNo())) * Avg(1), Active_Month))

I would like to ask you if i can use this measure by years and i want to apply it  until Year-1, it means that i would count all ROWS without the last Year. I wish you can help me :).

thank you in advance

[sgagliardi]

Hi Yassine,

Perhaps something involving the AddYears expression, with -1, like:

Max(Aggr(RangeSum(Above(Count(AddYears({<Active_Month, Active_Date>},-1)DISTINCT AccID), 0, RowNo())) * Avg(1), Active_Month))

[Sue_Macaluso]

Which product is this for QlikView or Sense? Id like to move it into the correct product forum.