Cumulating budget automatic per month

Fri, 03 Dec 2010 10:29:38 GMT

Hello you all,

I want to divide a budget into 12 months so I''ve created an inline table. The year budget is 500.000 and now I want to calculate this per month wit a cumulating calculation. So for example:

LOAD * INLINE [

Month Monthname calculate

2010-01 Januari 0,084931507

2010-02 Februari 0,161643836

2010-03 Maart 0,246575342

2010-04 April 0,328767123

2010-05 Mei 0,41369863

2010-06 Juni 0,495890411

2010-07 Juli 0,580821918

2010-08 Augustus 0,665753425

2010-09 September 0,747945205

2010-10 Oktober 0,832876712

2010-11 November 0,915068493

2010-12 December 1

];

Januari must be calculated like 500.000 * 0,084931507

Februari like 5000.000 * 0,161643836 and so on. December wil be 500.000 * 1 = year end (this is the easy part), but now I want the system to know what month it is without selecting a month manualy. For example: It's November so I want the system to calculate 500.000 * 0,915068493 = 457.534,25 (cumulating budget untill this month)

Can anyone help?

Cumulating budget automatic per month

googel84 — Fri, 03 Dec 2010 11:46:24 GMT

I'm not sure of having got your message but I'll try.

First of all align Monthname column to the list of month names set into MontNames variable. Then, set a trigger that selects in Monthname field the value calculated with month(today()).

Hope it helps.

topic Cumulating budget automatic per month in QlikView

Cumulating budget automatic per month

Cumulating budget automatic per month