topic Re: Accumulation on Months in Script in QlikView

123

Anonymous — Thu, 13 Apr 2017 10:53:30 GMT

ABC

MK_QSL — Thu, 13 Apr 2017 10:58:04 GMT

Front end or back end?

MK_QSL — Thu, 13 Apr 2017 11:03:37 GMT

IF(RowNo() = 1, SUM(TOTAL Sales), SUM(TOTAL Sales) - RangeSum(Above(SUM(Sales),0,RowNo())))

Small Change..

IF(RowNo() = 1,

SUM(TOTAL Sales),

SUM(TOTAL Sales) - RangeSum(Above(SUM(Sales),1,RowNo()))

)

MK_QSL — Thu, 13 Apr 2017 11:07:50 GMT

And if you want the same Value even after selection of Year or Month, use below expression

IF(RowNo() = 1,

SUM({<Year, Month>}TOTAL Sales),

SUM({<Year, Month>}TOTAL Sales) - RangeSum(Above(SUM({<Year, Month>}Sales),1,RowNo()))

) * Avg(1)