Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
smilingjohn
Contributor 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

Re: Accumulate

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)))
3 Replies
madhu_r
New Contributor II

Re: Accumulate

Hi,

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

 

Partner
Partner

Re: Accumulate

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

Re: Accumulate

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)))