Cumulative

[Anonymous]

Hello All

I need a urgent help.. Please help me in this scenario.

I am calculating the running total in visualization based on the months.

When I click on any particular month, the running total is failed.

Is there any way to fix the running total??

I tried to use {1} value to make them static but the issue with that I am not able to filter that value via different filters

Thanks!!

New to Qlik Sense‌

[sunny_talwar]

Try this:

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

[Anonymous]

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

Thanks Again

Regards

Deepanshu

[renjithpl]

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, ?

[yassine1992]

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 

[sunny_talwar]

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

[Uzumaki_N]

Hi @sunny_talwar 

Can you please explain the use of  Avg(1) ?

Thanks