topic Problem with Accumulated Function in QlikView

Problem with Accumulated Function

Wed, 16 Mar 2011 20:37:19 GMT

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

Wed, 16 Mar 2011 20:55:03 GMT

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

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

Thu, 17 Mar 2011 11:46:46 GMT

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

Thu, 17 Mar 2011 11:48:27 GMT

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

Mon, 21 Mar 2011 20:04:07 GMT

I don´t find solutions....

Any suggestions???

Thanks