topic Problem with Rolling 12 months in QlikView

Problem with Rolling 12 months

Wed, 01 Oct 2014 15:09:08 GMT

Hello Everyone,

I am using below variables and expressions to get rolling 12 months data.

variables:

vMaxYearMonth=max({<Flag={'XXX'}>} Date( Date# ( Month&'-'&Year_No,'MMM-YYYY'),'MMM-YYYY'))

(vMaxMonthYear_PY12)==date(AddMonths(vMaxYearMonth,-11),'MMM-YYYY')

Expression:

=(sum({$<Year_No={$(vCY)},DATE=,WeekStart=,Month=,Year_No=,Month_Year={'>=$(vMaxMonthYear_PY12) <=$(vMaxYearMonth)'}>}aggr(sum({$<Year_No={$(vCY)},DATE=,WeekStart=,Month=,Year_No=,Month_Year={'>=$(vMaxMonthYear_PY12) <=$(vMaxYearMonth)'}>}D360.Revenue_Prop),CODE,Month_Year)))

but i am not getting any value. my data at date level,

Can any body tell me where i am doing mistake

Thanks

Re: Problem with Rolling 12 months

PrashantSangle — Wed, 01 Oct 2014 15:15:56 GMT

Hi,

It is really long expression, Very difficult to find error.

But still you can try like below

1: Write your variable Name in text Object.

Did you get any value for it

vMaxYearMonth=max({<Flag={'XXX'}>} Date( Date# ( Month&'-'&Year_No,'MMM-YYYY'),'MMM-YYYY'))

(vMaxMonthYear_PY12)==date(AddMonths(vMaxYearMonth,-11),'MMM-YYYY')

I am not getting why there is == in your variable

Regards

Re: Problem with Rolling 12 months

HirisH_V7 — Fri, 30 Oct 2015 09:29:09 GMT

hi,

You can use like this at calendar At back end

If(Date>= AddMonths(Today(), -12), 1)as Last12MonthFlag

At front end

Last12MonthFlag={1}

Hope this Helps

Regards,

hirish