Month-to-Month growth

[#1]

Hi,

Required: Month-to-month growth

Period	Revenue
2012  Dec	€ 4636802
2013  Jan	€ 4849272
2013 Feb	€ 4898024
2013 Mar	€ 4883361
2013 Apr	€ 6017844
2013 May	€ 5920954

If I select Year = 2013, I would like to get something like that

Period	Revenue	Growth% P-P-1
2013  Jan	€ 4.849.272	5%
2013 Feb	€ 4.898.024	1%
2013 Mar	€ 4.883.361	0%
2013 Apr	€ 6.017.844	23%
2013 May	€ 5.920.954	-2%

One way to solve this out is using the the above() function. This however wil produce null() growth for the first period. since the user can stil select a year this is no option.

try this:

SUM([# Revenue] / 
ABOVE(         
          If(PeriodeSeq = MIN(TOTAL aggr(Min(PeriodeSeq),%Periode)) ,
                                  $(vRevenue1stPeriod),
                                  SUM([# Revenue]))
             )

where

SET vRevenue1stPeriod = sum({1<Year=, Period = ,PeriodeSeq = {'$(=MIN(TOTAL aggr(Min(PeriodeSeq),%Periode))-1)'}>}[# Revenue])

This obviously didnt work since set analysis are evaluated one time per chart....

Ideas will be welcome

[#2]

Hi,

Still struggling here. Any ideas?

Dror

[Gysbert_Wassenaar · Accepted solution]

Same problem as here. The AsOf table in the posted example should work for you too.

[#4]

This is a certainly a step forward. Funny that Qlikview cannot tuckle this natively. The ability to have period-to-period seems to me as a "must have" feature.