topic Re: Accumulate in QlikView

Accumulate

smilingjohn — Wed, 25 Nov 2020 16:16:04 GMT

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

madhu_r — Wed, 12 Jun 2019 06:01:21 GMT

Hi,

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

lironbaram — Wed, 12 Jun 2019 06:15:01 GMT

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

sunny_talwar — Wed, 12 Jun 2019 12:45:55 GMT

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