topic Re: Cumulative balance pivot table within one dimension in QlikView

Cumulative balance pivot table within one dimension

bartvanwetten — Fri, 01 Apr 2016 12:29:08 GMT

Can someone help me out on this one?

The pivottable in the attached document shows a financial (cumulative) balance.

But it should be only cumulative every month WITHIN one year only. So when the balance goes from 2013/12 to 2014/00 it should start cumulating from 2014/00 on.

Thanks everyone in advance for the input!

Re: Cumulative balance pivot table within one dimension

sunny_talwar — Fri, 01 Apr 2016 21:41:19 GMT

Can you try this:

RangeSum(Before(TOTAL Sum({<Periode=,PeriodeNew={'<=$(vBalansPeriodMax)'}, Bron = {'result'}, RekeningType={'Balans'}>} amount), 0,

Num(Only({<Periode=,PeriodeNew={'<=$(vBalansPeriodMax)'}, Bron = {'result'}, RekeningType={'Balans'}>}TOTAL <Periode_Met_Nul_13_Naar_12> Periode_Only)) + 1))

Re: Cumulative balance pivot table within one dimension

bartvanwetten — Fri, 01 Apr 2016 22:04:51 GMT

Hi Sunny,

i'm truly impressed, EXACTLY what I needed, you made my day!

Kind regards,

Bart

Re: Cumulative balance pivot table within one dimension

sunny_talwar — Fri, 01 Apr 2016 22:09:30 GMT

Not a problem, I am glad I was able to help.

Re: Cumulative balance pivot table within one dimension

sunny_talwar — Fri, 01 Apr 2016 22:10:13 GMT

Also did you want to mark my answer as helpful (instead of yours)

Re: Cumulative balance pivot table within one dimension

bartvanwetten — Fri, 01 Apr 2016 22:12:29 GMT

hahah sunny, sorry man, i made yours helpful.

Re: Cumulative balance pivot table within one dimension

sunny_talwar — Fri, 01 Apr 2016 22:14:30 GMT

I was just playing around with you, but thanks