Skip to main content
Announcements
Global Transformation Awards! Applications are now open. Submit Entry
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Cumulative

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

25 Replies
sunny_talwar

Try this:

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

Anonymous
Not applicable
Author

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

Thanks Again

Regards

Deepanshu

renjithpl
Specialist
Specialist

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
Contributor II
Contributor II

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
Contributor III
Contributor III

Hi @sunny_talwar 

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

Thanks