topic Accumulation is not working in Qliksense pivot table. in App Development

Accumulation is not working in Qliksense pivot table.

Qlikbuddy — Wed, 26 Nov 2025 11:16:09 GMT

i am creating a churn details related pivot table, where i have created couple of expressions and they are fine in the pivot table. i have to create the cumulative churn for that i am using the below expression. i even tried sorting the column but values are coming as 0 or some unexpected values. kindly suggest what to do here.

RangeSum(Before(Count(DISTINCT {<TLD_Flag={1},Churn_Flag={1},Months_Diff_TLD_Start_End={">=-36 <=36"}>} Subscription_Id), Months_Diff_TLD_Start_End), 0, Rowno())

Churn expression :

= if(Count(Distinct {<TLD_Flag = {1},Churn_Flag= {1},Months_Diff_TLD_Start_End = {">=-36 <=36"}>} Subscription_Id)/1000 > 0,

Count(Distinct {<TLD_Flag = {1},Churn_Flag= {1},Months_Diff_TLD_Start_End = {">=-36 <=36"}>} Subscription_Id)/1000)

using this churn expression i have to create accumulation expression but its not working as expected.

I am using Months_Diff_TLD_Start_End as column and its a derived column from the back end script.

,(EXTRACT(YEAR FROM TLD_Expiry_Date) - EXTRACT(YEAR FROM Disc_Start_Date)) * 12

+ (EXTRACT(MONTH FROM TLD_Expiry_Date) - EXTRACT(MONTH FROM Disc_Start_Date)) AS Months_Diff_TLD_Start_End

Re: Accumulation is not working in Qliksense pivot table.

Nagaraju_KCS — Wed, 26 Nov 2025 14:03:29 GMT

May be this

Rangesum(
Above(
Count(DISTINCT {<TLD_Flag = {1},Churn_Flag = {1},Months_Diff_TLD_Start_End = {">=-36 <=36"}
>} Subscription_Id) / 1000,
0,
RowNo(TOTAL))
)

Re: Accumulation is not working in Qliksense pivot table.

marcus_sommer — Thu, 27 Nov 2025 13:44:30 GMT

The general approach is ok. but by more complex objects it may need some total-statements and/or even wrapping it with an aggr() maybe like:

rangesum(before(TOTAL MyExpr, 0, rowno(TOTAL)))

aggr(rangesum(before(TOTAL MyExpr, 0, rowno(TOTAL))), Dim1, Dim2)

I suggest to start with a new chart and only a single dimension + MyExpr and the accumulation. If it worked like expected you could add step by step more complexity.