As of Calendar by date

[menta]

Hi all,

I would like to create an asof calendar using date field.

I need to create dimensions for 12 rolling months, previous year.

This is my code but there is something wrong i thought:

LOAD

  Date as AsOfDate

// Period as AsOfPeriod

,'Current' as PeriodType

,Date

,Year(Date) as Anno

,Date(Date,'YYYYMM') as YearMonth

RESIDENT CALENDARIO;

CONCATENATE (AsOfPeriodTable)

//Load Rolling 3 into AsOf table

LOAD

Date as AsOfDate

,'Rolling 12' as PeriodType

,date(addmonths(Date,1-iterno())) as Date

,Year(Date) as Anno

,Date(Date,'YYYYMM') as YearMonth

RESIDENT CALENDARIO

WHILE iterno() <= 12;

CONCATENATE (AsOfPeriodTable)

//Load Rolling 6 into AsOf table

LOAD

Date as AsOfDate

,'PreviousYear' as PeriodType

,date(AddMonths(Date,-12)) as Date

,Year(Date) as Year

,Date(Date,'YYYYMM') as YearMonth

RESIDENT CALENDARIO

;

Right JOIN (AsOfPeriodTable)

LOAD Date

RESIDENT CALENDARIO;

[#2]

Hi, Carlo!

What is the problem of your code? Is there a error during execution or is the result wrong?

[richard_pearce6]

Here is an AsOf calendar Carlo

http://community.qlik.com/docs/DOC-6593

Regards

Richard

QlikCentral.com

[amit_saini]

Carlo,

Please see the attachment.

Thanks,

AS

[menta]

This example is useful for previous year and previous period, but how can i create the rolling on this?

Thank you

[richard_pearce6]

Hi Carlo,

Examples of rolling are "Last" flags.

%Flag_LastMonth_M01  If  Date=6th Jan 2014 would select KeyDate's 6th Dec 2013 to 6th Jan 2014

For a rolling year you would use  %Flag_LastMonth_M12

Regards

Richard