4 Replies Latest reply: Mar 21, 2011 4:04 PM by ezequiel.villemur

# Problem with Accumulated Function

Hi, I`m new user of QlikView, and i have a problem with the acumulated function.

Have fields, Month, Year and combinated Year/Month.

I need accumulate in a pivot table, the sum of cost (nValor) of the year 2010 and year 2011 separated

How I determine inferior limits?? example 2010/01 and 2011/01
If the user maks feb/2011, in first column need the accum of 2011(jan+feb 2011) and other column the accum of 2010 (jan+feb2011)

I tried with Rangesum and Accumulated Function.
Sorry my english I am a little rusty
THANKS!!!!
• ###### Problem with Accumulated Function

Hi

You need to use set analysis to create point in time analysis.

I suggest to look at mike's blog http://iqlik.wordpress.com/2010/11/27/the-magic-of-set-analysis-point-in-time-reporting/

The formula to calculate a year to date looks like :

for the current year

=sum( { \$<MOIS = {\$(=Max( MOIS))} ,
ANNEE = {\$(=Max( ANNEE))}
> }

Sales)

and for the previous year

=sum( { \$<MOIS = {\$(=Max( MOIS))} ,
ANNEE = {\$(=Max( ANNEE)-1)}
> }

Sales)

hope it helps

JJ

• ###### Problem with Accumulated Function

I send a pic from my table. With the formula suggested, in accumulated gives back the value of the present month.