Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Partner
Partner

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

1 Solution

Accepted Solutions
Highlighted
Partner
Partner

Re: Need running total in pivot table in qlikview

Does this expression suit your need?

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

 

Plees ekskuse my Swenglish and or Norweglish spelling misstakes

View solution in original post

1 Reply
Highlighted
Partner
Partner

Re: Need running total in pivot table in qlikview

Does this expression suit your need?

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

 

Plees ekskuse my Swenglish and or Norweglish spelling misstakes

View solution in original post