Consecutive 12 Months calculation Expression

Tue, 25 Feb 2014 20:53:57 GMT

Hello

In the below expression I am trying to calculate 12 months or 12 periods from my chosen period. But it is not coming out correctly. Is there a way to simplify this expression to get what I am trying to do.

If([Currency]='Transactional',

Sum ($(vfsa-Deferred Revenue)If([GL Date] < date("$(=[End Period])"+12) and [GL Date] >= "$(=[Start Period])" and [Initial Entry Flag]='N'and [Schedule Created End Date] < date("$(=[End Period])"+12) and [Schedule On Hold]='N' ,[Net Amount],0)),

If([Currency]='Functional',

Sum ($(vfsa-Deferred Revenue)If([GL Date]< date("$(=[End Period])"+12) and [GL Date] >= "$(=[Start Period])" and [Initial Entry Flag]='N'and [Schedule Created End Date] < date("$(=[End Period])"+12) and [Schedule On Hold]='N',[Net Amount Operating Currency],0)),

If([Currency]='Reporting',

Sum ($(vfsa-Deferred Revenue)If( [GL Date] < date("$(=[End Period])"+12) and [GL Date] >= "$(=[Start Period])" and [Initial Entry Flag]='N'and [Schedule Created End Date] < date("$(=[End Period])"+12) and [Schedule On Hold]='N',[Net Amount Reporting Currency],0)),0

// Sum ($(vfsa-Revenue)If([GL Date]>= $(=[StartPeriod]) AND [GL Date]<= ($(=[EndPeriod])+12),[Net Amount],0))

)

Thanks

Riz

topic Consecutive 12 Months calculation Expression in QlikView

Consecutive 12 Months calculation Expression