Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
Nora104
Partner - Creator
Partner - Creator

How does the pivot table accumulate weekly calculations

The below is sales quantity of every week:

1.png


I want it to be like this, 
cumulative calculation weekly:

2.png
But I don't know how to write the formula.

I use the formula:sum(total<Code>Qty)

But the result is the below:

3.png
How can I write the formula?

1 Solution

Accepted Solutions
martinpohl
Partner - Master
Partner - Master

in pivot table, the accumulate button is not available

use this expression:

rangesum(before(sum(Qty),0,99))

Regards

View solution in original post

2 Replies
sergio0592
Specialist III
Specialist III

Hi,

Maybe try to check 'Accumulate' box in Expression tab.

T1.png

 

martinpohl
Partner - Master
Partner - Master

in pivot table, the accumulate button is not available

use this expression:

rangesum(before(sum(Qty),0,99))

Regards