Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
tripatiqv
Partner - Contributor III
Partner - Contributor III

Need running total in pivot table in qlikview

Dear All,

Our requirement is We need running total in pivot table.

For Example On 5th of Jan we need sum of sales from 1st Jan to 4th Jan.

I have attached qlikview file and excel file.

 

Please check

Labels (2)
1 Solution

Accepted Solutions
Vegar
MVP
MVP

Does this expression suit your need?

=RangeSum(Above(Sum(Sales), 0, RowNo()))

 

View solution in original post

1 Reply
Vegar
MVP
MVP

Does this expression suit your need?

=RangeSum(Above(Sum(Sales), 0, RowNo()))