Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator III
Creator III

Accumulate

Hi Expetise

I have a table diplaying the accumulative earnings for each year for a striaght table .

How do i achive this accumalative in a pivot table . Can you experty please help me on this ?

Please find my attchment of the QVW .

Thanks in Advance

1 Solution

Accepted Solutions
Highlighted

You can use this

Aggr(RangeSum(Above(Sum(Earnings), 0, RowNo())), Year)

or this if you use QlikView 12 or above

Aggr(RangeSum(Above(Sum(Earnings), 0, RowNo())), (Year, (NUMERIC)))

View solution in original post

3 Replies
Highlighted
Contributor II
Contributor II

Hi,

Use this expression in pivot table : RangeSum(Above(Sum(Earnings),0,RowNo()))

 

Highlighted
Partner
Partner

hi 

per your table this expression will do the trick 

Rangesum(before(sum(Earnings),0,ColumnNo()))

but if the user will drag the year dimension to the left , the expression won't work 

so you need to make sure the user can't change the table structure

Highlighted

You can use this

Aggr(RangeSum(Above(Sum(Earnings), 0, RowNo())), Year)

or this if you use QlikView 12 or above

Aggr(RangeSum(Above(Sum(Earnings), 0, RowNo())), (Year, (NUMERIC)))

View solution in original post