topic cumulative value in QlikView

cumulative value

Anonymous — Wed, 29 Sep 2010 11:08:42 GMT

How to get cumulative values for 2 years.

i.e. i am getting cumulative value from jan-08 to Dec 08.

But the cumulative for Jan -09 should be addition of Dec -08 + Jan 09 and so on..

Please Help.

cumulative value

Miguel_Angel_Baeyens — Wed, 29 Sep 2010 12:23:05 GMT

Hello,

You can use AddMonths() function, that will return all previous 12 months

LET vDateFrom = AddMonths(Today(), -12);

Hope that helps

cumulative value

Anonymous — Thu, 30 Sep 2010 08:05:03 GMT

I want to calculate cumulative values from Dec 2008 to Mar 2010.

I am able to get cumulative from Jan 09 to Dec 09 and also from Jan2010 to Mar 2010,

but
not able to add dec 08 values to jan 09 .