Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
bartvanwetten
Contributor

Cumulative in pivot table (financial balance, debtors)

Hi all,

in attached document there is a pivot table with a financial balance with Debtors. I can't get it cumulative. I used rangesum() but somehow I never get the needed result. There's a picture in it with the right cumulative results in Excel.

Thx everyone!

Bart

1 Solution

Accepted Solutions
MVP
MVP

Re: Cumulative in pivot table (financial balance, debtors)

Use

=rangesum(Before(TOTAL Sum({<Hoofdgroep ={'3'},Subgroep={'2'}, Bron = {'result'}, RekeningType={'Balans'}>} amount),0,ColumnNo(Total)))

or

=rangesum(Before(Sum({<Hoofdgroep ={'3'},Subgroep={'2'}, Bron = {'result'}, RekeningType={'Balans'}>} amount),0,ColumnNo(Total)))

View solution in original post

5 Replies
MVP
MVP

Re: Cumulative in pivot table (financial balance, debtors)

Use

=rangesum(Before(TOTAL Sum({<Hoofdgroep ={'3'},Subgroep={'2'}, Bron = {'result'}, RekeningType={'Balans'}>} amount),0,ColumnNo(Total)))

or

=rangesum(Before(Sum({<Hoofdgroep ={'3'},Subgroep={'2'}, Bron = {'result'}, RekeningType={'Balans'}>} amount),0,ColumnNo(Total)))

View solution in original post

bartvanwetten
Contributor

Re: Cumulative in pivot table (financial balance, debtors)

Many many thx Manish! Exactly the right answer!

MVP
MVP

Re: Cumulative in pivot table (financial balance, debtors)

Can you close the thread by selecting my answer correct so that others can also use it..?

bartvanwetten
Contributor

Re: Cumulative in pivot table (financial balance, debtors)

Sure sure, but the only action I can see is 'Mark as useful' ?

MVP
MVP

Re: Cumulative in pivot table (financial balance, debtors)

Whatever you can do...!