topic How to divide between previous year in QlikView

How to divide between previous year

I have a table with states / year / month dimensions, I need to calculate the following formula:

T = Value_Month_Year / Value_Month_PreviousYear

And I need a second table to show:

T = Value_Month_Year / Value_Month_PreviousYear

For All the Years since 2010

How can I achieve this???

Thanks in advance

Berenice

ramoncova06 — Wed, 15 Apr 2015 02:20:16 GMT

what is the current expression that you are using ?

how does your date field looks ?

you could probably do something like this

sum(value)

sum({<month = {">=$(=(addyears(month,-1)))"}>}value)

Wed, 15 Apr 2015 15:38:40 GMT

Thanks,

I'm using this expression:

Avg(ActividadInd)

Avg({<Año = {$(=Year(AddYears(MakeDate(Año,Mes),-1)) )}, Año = >} ActividadInd)

But in my table obviously the value is divided by itself because I'm ignoring the year selected

I've attached the qv file