topic Re: accumulate in pivot table in QlikView

accumulate in pivot table

bartvanwetten — Wed, 26 Oct 2016 18:43:38 GMT

Dear all,

can someone help me out on this one?

Attached you find a sheet (red marked) with a pivot table. (Financial balance)

The amounts are already cummulated but it should cumulate only in one year and not over the year.

In fact, the end of year 2014 should be the same as the beginning of 2015 and so on.

Thanks in advance!

Bar

Re: accumulate in pivot table

sunny_talwar — Wed, 26 Oct 2016 18:47:30 GMT

I sort of understand you issue, but can you help me understand better by pointing out the exact number you are looking to get?

Re: accumulate in pivot table

bartvanwetten — Wed, 26 Oct 2016 18:55:17 GMT

Sunny,

you can set the dimension variable to for example 'Periode'. Than you'll get the numbers over the months. The first month of every next year should be the amount of the last month in the previous year. So it shoult cummulate over tthe months but in ONE year and not over the year. Am I making my self clear?

Thanks!

Bart

Re: accumulate in pivot table

sunny_talwar — Wed, 26 Oct 2016 19:01:32 GMT

Where do I go to set the dimension variable? Variable Overview?

Re: accumulate in pivot table

bartvanwetten — Wed, 26 Oct 2016 19:03:19 GMT

Yes: vPeriodeSelectieBalans

There you find the fields used for the dimension

Re: accumulate in pivot table

bartvanwetten — Wed, 26 Oct 2016 19:28:04 GMT

Sunny,

Now I remember I asked you a very similair issue some time ago but i can't find it in my history.

Can you find history between you and me? I blessed you that day I remember

Bart

Re: accumulate in pivot table

sunny_talwar — Wed, 26 Oct 2016 19:32:18 GMT

This?

Cumulative balance pivot table within one dimension

Re: accumulate in pivot table

bartvanwetten — Wed, 26 Oct 2016 19:39:38 GMT

Yes,

but I see it is nog what im looking for now hmz.

Are you getting along with my challenge of today?

Thanks!

Re: accumulate in pivot table

sunny_talwar — Wed, 26 Oct 2016 19:42:25 GMT

I want to, but I am not sure what numbers are you looking to get . May be if we can provide with me some directions, I might be able to help you out

Re: accumulate in pivot table

bartvanwetten — Wed, 26 Oct 2016 19:47:04 GMT

Maybe we can have a skype call? and some teamviewer?

Re: accumulate in pivot table

bartvanwetten — Wed, 26 Oct 2016 20:50:25 GMT

Hi Sunny,

As soon as another year starts it starts with month 00. Wich is the cum.amount of the year before.

So every year it shout start cumulating from 00 on. So cumulate 201400 to 2014 12, then cumulate new from 201500 to 201512. What it dow now is cumulate from 201400 to 201609. It should cumulate in the year only.

Ok?

Thx for waching again!

Re: accumulate in pivot table

bartvanwetten — Wed, 26 Oct 2016 22:31:45 GMT

Range Sum Iterate Over Years

Sunny it looks like the solution is to find in above discussion, but i can't get it into the formula in the first attachment.

Please help? If you like I will be pleased to offer you a fee!

Regards,

Bart