Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Highlighted
suvechha_b
Contributor 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
Highlighted

Re: How to do cumulative number in qliksense pivot table ?

Try this

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

View solution in original post

4 Replies
Highlighted

Re: How to do cumulative number in qliksense pivot table ?

May be this

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

Re: How to do cumulative number in qliksense pivot table ?

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

 

 

Highlighted

Re: How to do cumulative number in qliksense pivot table ?

Try this

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

View solution in original post

Highlighted
suvechha_b
Contributor III

Re: How to do cumulative number in qliksense pivot table ?

Thank you .