topic Re: CALCULATE EXPRESSIONS FOR LAST 12 Months !! in QlikView

CALCULATE EXPRESSIONS FOR LAST 12 Months !!

Mon, 08 Dec 2014 04:51:39 GMT

I am creating a report where i need to show data for last 12 months , For e.g ( if i enter date as 5 nov 2014 , then it should show me data from nov 2013 to oct 2014 ) .

Till Now i have created a field with MonthName() function in my script which gives me month along with the year like ( Dec 2014 ,sep2013) .

Can somebody suggest me the logic which i need to apply over here .

Thanks in advance !!

Re: CALCULATE EXPRESSIONS FOR LAST 12 Months !!

PrashantSangle — Mon, 08 Dec 2014 05:06:51 GMT

Hi,

Try like

Sum({<datefield={">=$(Date(Addmonths(max(datefield),-12)))<=$(=Date(max(datefield)))}>}Amount)

Regards

Re: CALCULATE EXPRESSIONS FOR LAST 12 Months !!

ashwanin — Mon, 08 Dec 2014 05:18:21 GMT

Re: Set Analysis for last 13 months of Data

Re: CALCULATE EXPRESSIONS FOR LAST 12 Months !!

ashfaq_haseeb — Mon, 08 Dec 2014 06:55:21 GMT

Hi,

Check this too

Sum({<DATE={">=$(=MonthStart(Max(DATE),-12)) <=$(=MonthEnd(Max(DATE)))"}>} SALES)

Regards

ASHFAQ

Re: CALCULATE EXPRESSIONS FOR LAST 12 Months !!

SunilChauhan — Mon, 08 Dec 2014 07:02:25 GMT

Sum({<datefield={">=$(Date(Addmonths(max(datefield),-12)))<$(=Date(max(datefield)))}>}Amount)

Re: CALCULATE EXPRESSIONS FOR LAST 12 Months !!

Mon, 08 Dec 2014 07:06:49 GMT

Hi,

Try like

Sum({<datefield={">=$(Date(Addmonths(max(datefield),-12)))<=$(=monthend(addmonths(max(datefield),-1))}>}Amount)

Regards

Re: CALCULATE EXPRESSIONS FOR LAST 12 Months !!

SunilChauhan — Mon, 08 Dec 2014 07:11:50 GMT

yes ashok,you are right .my formula calculate before today and last 12 months

Re: CALCULATE EXPRESSIONS FOR LAST 12 Months !!

PrashantSangle — Mon, 08 Dec 2014 08:34:31 GMT

Hi,

I missed the = sign in set anlysis

update

Sum({<datefield={">=$(=Date(Addmonths(max(datefield),-12)))<=$(=Date(max(datefield)))}>}Amount)

Regards