Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Tell us which business and trade publications you read most regularly: RESPOND NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
deepanshu_chamo1
Contributor
Contributor

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

24 Replies
sunny_talwar

Try this:

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

deepanshu_chamo1
Contributor
Contributor
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?