Qlik Community

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
rxf67787
Contributor II
Contributor II

Running Total Calculation on Calculated Field

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.

 

Qlik Sense Image.PNG

2 Replies
robert99
Specialist III
Specialist III

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

 

 

 

rxf67787
Contributor II
Contributor II
Author

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.