Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Re: Cumulative

Try this:

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

New Contributor

Re: Cumulative

Thanks a lot for your time Sir. The issue has been resolved

Thanks Again



Valued Contributor

Re: Cumulative

HI Sunny, I was going through same issue. this solution helped to achieve it. Thanks.
Can you explain why the avg(1) is used here, ?
New Contributor II

Re: Cumulative

Hi @sunny_talwar  thank you for this great solution,

but for my case i want the same measure  by years and on previous years (YEAR-1), it means that i like to have the sum without values of last year

thank you in advance 

Re: Cumulative

Would you be able to share  a sample to show the issue?