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

Cumulative in pivot table (financial balance, debtors)

bartvanwetten — Thu, 10 Sep 2015 13:38:44 GMT

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

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

MK_QSL — Thu, 10 Sep 2015 13:59:30 GMT

Use

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

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

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

bartvanwetten — Thu, 10 Sep 2015 14:30:36 GMT

Many many thx Manish! Exactly the right answer!

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

MK_QSL — Thu, 10 Sep 2015 14:37:53 GMT

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

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

bartvanwetten — Thu, 10 Sep 2015 14:40:58 GMT

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

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

MK_QSL — Thu, 10 Sep 2015 14:45:19 GMT

Whatever you can do...!