Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
suvechha_b
Creator III
Creator III

Expression for cummulative sum

How to do the following expression :

snap.PNG

Trading Day  :                  New

       3                            4314965

       4                            8629930

...

...

...

         19                        81984344

and Total shoulbe also 81984344

I am using variables :

Column Budget : vBudget : sum({$<TranType = {'Budget_$(vAmountType)'},CurrentPer = {1},Fiscal_Year = {$(=max(Fiscal_Year))}>} Amount)

Column New : vNew :  sum({$<TranType = {'Budget_$(vAmountType)'},CurrentPer = {1},Fiscal_Year = {$(=max(Fiscal_Year))}>} Amount)/no_trading_days

Unable to upload sample model.

1 Reply
MK_QSL
MVP
MVP

For Cumulative Total

RangeSum(Above(SUM(Sales),0,RowNo()))

or

RangeSum(Above(TOTAL SUM(Sales),0,RowNo(TOTAL)))

Replace SUM(Sales) with your Expression.