Qlik Community

Community Corner

Discussion board for questions about the Qlik Community, its features, sharing information, general discussions and even some fun. This is for both new and longtime community members. Everyone is welcome!

yassine1992
New Contributor II

Cumulative count until YEAR-1 (Previous Year)

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

Labels (3)
2 Replies
sgagliardi
New Contributor II

Re: Cumulative count until YEAR-1 (Previous Year)

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))

Community Manager
Community Manager

Re: Cumulative count until YEAR-1 (Previous Year)

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