topic Re: Running Total Calculation on Calculated Field in App Development

Running Total Calculation on Calculated Field

rxf67787 — Tue, 19 Mar 2019 18:28:49 GMT

Hello,

I did see some other posts in the Qlik Community, but none that seemed to work for resolving my issue. I have data pulled in from an Excel Sheet into Qlik Sense. I was able to pull in the number of completed requests and % of Completed requests. The formula used for % of Completed Requests is:

Count([Approval Completed Date 2])/Count(TOTAL [Approval Completed Date 2])

I am trying to do an additional calculation to get the Running Total Percentage (Please see attached Excel File of the data and screenshot showing the current display in Qlik Sense).

I'd like/expect the Columns to look most likely as the below is displayed (Also will be able to see in the Excel sheet)

Completed Requests % of Completed Requests Total Running Percentage

155 100% ---

84 54.19% 54.19%

61 39.35% 93.54%

9 5.81% 99.35%

1 0.65% 100%

I want to ensure that any additional months and years will update accordingly as well.

Re: Running Total Calculation on Calculated Field

robert99 — Tue, 19 Mar 2019 22:13:40 GMT

Hello

Have you had a look at AsOfPeriod. It's what I use for accumulations.

Ive never had to do accumulation by Month. But assume you would set

Sum({$<MonthDiff={0}>} Sales)

https://community.qlik.com/t5/Qlik-Design-Blog/The-As-Of-Table/ba-p/1466130

Re: Running Total Calculation on Calculated Field

rxf67787 — Thu, 28 Mar 2019 13:25:58 GMT

I did try and look at what you suggested but that didn't work for me. I'm also not looking to create a bunch of additional tables and linkages for this.