Problem with Accumulated Function

[#1]

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!!!!

[#2]

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

[#3]

Thanks for your answer. The formula don´t works

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

Help Please!!!!

[#4]

ADD THIS PICTURE. In case the user marks 2011/03, the table must show 2011/01 + 2011/02 + 2011/03.

[#5]

I don´t find solutions....

Any suggestions???

Thanks