Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld Online 2021, May 10-12: Our Free, Virtual, Global Event REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
suvechha_b
Creator III
Creator III

How to do cumulative number in qliksense pivot table ?

Hi All ,

Please kindly assist me to get the cumulative number for the below table .

How to get the cumulative value - R1,621,456

                                                                      R1,621,456 +  R9,372,516

                                                                      R1,621,456 +  R9,372,516 + 6,899,589 and so on

Cumulative value like the arrow shows from below to top -

Cumulative.PNG

 

1 Solution

Accepted Solutions
sunny_talwar

Try this

Sum(
Aggr(RangeSum(Above(Sum(Measure), 0, RowNo())), [UW Month], ([Claims Payment Month], (NUMERIC)))
)

View solution in original post

4 Replies
sunny_talwar

May be this

Aggr(RangeSum(Above(Sum(Measure), 0, RowNo())), [UW Month], ([Claims Payment Month], (NUMERIC)))
suvechha_b
Creator III
Creator III
Author

Hi Sunny ,

It works, but the total is not working . Please see the image below -

Total should be = R10,993,972 + R 2,391,220 ?

Total1.PNG

 

 

sunny_talwar

Try this

Sum(
Aggr(RangeSum(Above(Sum(Measure), 0, RowNo())), [UW Month], ([Claims Payment Month], (NUMERIC)))
)

View solution in original post

suvechha_b
Creator III
Creator III
Author

Thank you .