topic Rolling 6 months in QlikView

Rolling 6 months

Wed, 15 Sep 2010 15:51:35 GMT

Hi!

I want to calculated the sum of 6 rolling months in a table graph dynamically based on the period selected by the user.

If the user select period 201006 (i.e PeriodCounter) I want the table to sum the amount for 201001-201006.

I'm trying to use this expression but i don't get the correct result. What am I doing wrong?

sum({$< PeriodCounter = {">$(=max(PeriodCounter)-6)"},PeriodCounter = {"<=$(=max(PeriodCounter))"},[Year Month]={"*"}>} Amount))

Zandra

Wed, 15 Sep 2010 18:22:04 GMT

I had the same problem......and use this

sum( { < Period_Counter= {">=$(var_inicio)<=$(var_final)"} >} Amount )

Where i set the variables:

var_inicio = NUM(MonthName(AddMonths(Period_Counter,-6)))

var_final = NUM(Period_Counter)

If you have some doubt....ask me...

Thu, 30 Sep 2010 09:22:57 GMT

Thank you!

I managed to solve it another way:

= sum({$< PeriodCounter = {">$(#=max(PeriodCounter)-6) <=$(#=max(PeriodCounter))"},[Year Month]={"*"} >} Amount)