Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
BI & Data Trends 2021. Discover the top 10 trends emerging in today. Join us on Dec. 8th REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor II
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

2 Replies
Highlighted
Contributor III
Contributor III

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

Highlighted
Community Manager
Community Manager

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