Qlik Community

New to Qlik Community

Discussion board for questions on how to use Qlik Community and its features.

Not applicable

Accumulated Figures??

HI there,

I want to include the budgeted figures next to our Actual figures for Comparison.

But the table (information) that I pull from out System accumulates the figures.

i.e. For the month of July it only gives me the month of July's figures. But the budgeted figure for August is July plus August.

September's budget is then September plus August (July and August) and so on.

Can someone please help me with a formula, either in the back or front-end. So if I want August it should Take August and subtract July??

Thanks

*R*

1 Solution

Accepted Solutions
baa
Contributor

Re: Accumulated Figures??

Hi,

Take a look at the attachement.

Regards,

Brice

5 Replies
simondachstr
Valued Contributor III

Re: Accumulated Figures??

rangesum(before(sum(Budget),1,ColumnNo()))

This should give you the accumulated total budget sum for each month up to that date. Not sure though if it's the cleverest way to solve that.

baa
Contributor

Re: Accumulated Figures??

Hi,

Take a look at the attachement.

Regards,

Brice

Not applicable

Re: Accumulated Figures??

Hi Brice,

Thank you...the formula that you attached works perfectly.

Only thing now is my new field called Budget now shows July (which is my first month) now shows a big amount and then the rest shows per month??

Thanks

*R*

baa
Contributor

Re: Accumulated Figures??

You need to know the value for June if you want to get the value for July. Indeed, the idea is to substract the accumulated value for month N-1 to the accumulated value of month N to get the value for month N.

Then, if you want to compute the value for June, you'll need the value for May, etc.

If you don't have this information, I don't see how you can get the value for July .

Brice

Not applicable

Re: Accumulated Figures??

Hi there,

I see what your saying.

Will see if I can get the June figure somewhere.

Thanks

*R*

Community Browser