How this script works for creating period ?

Tue, 04 Oct 2016 11:02:53 GMT

Can somebody help me in understanding the below code . I am completely fed up after trying so many times.

// Add Period1 field to be able to associate with the AsOf table

REV:

Load

MonthStart(Date(Date(Date#(MonthYear,'MMM-YYYY'),'DD-MM-YYYY'),'YYYYMM')) as Period1,

MonthName(MonthNo) as Month

From REV.qvd(qvd);

// Temporary table with list of Period values

PeriodTbl:

LOAD date(fieldvalue('Period1',recno()),'YYYYMM') as Period

AUTOGENERATE fieldvaluecount('Period1');

AsOf:

//Load every month as current month into AsOf table

LOAD

Period as AsOfPeriod

,'Current' as PeriodType

,Period as Period1

,Year(Period) as Year

RESIDENT PeriodTbl;

CONCATENATE (AsOf)

//Load Rolling 3 into AsOf table

LOAD

Period as AsOf

,'Rolling 3' as PeriodType

,date(addmonths(Period,1-iterno()),'YYYYMM') as Period1

,Year(Period) as Year

RESIDENT PeriodTbl

WHILE iterno() <= 3;

CONCATENATE (AsOf)

//Load Rolling 6 into AsOf table

LOAD

Period as AsOf

,'Rolling 6' as PeriodType

,date(addmonths(Period,1-iterno()),'YYYYMM') as Period1

,Year(Period) as Year

RESIDENT PeriodTbl

WHILE iterno() <= 6;

CONCATENATE (AsOf)

//Load Rolling 12 into AsOf table

LOAD

Period as AsOf

,'Rolling 12' as PeriodType

,date(addmonths(Period,1-iterno()),'YYYYMM') as Period1

,Year(Period) as Year

RESIDENT PeriodTbl

WHILE iterno() <= 12;

CONCATENATE (AsOf)

//Load YTD into AsOf table

LOAD

Period as AsOf

,'YTD' as PeriodType

,date(addmonths(Period,1-iterno()),'YYYYMM') as Period1

,Year(Period) as Year

RESIDENT PeriodTbl

WHILE iterno() <= num(month(Period));

INNER JOIN (AsOf)

LOAD Period as Period1

RESIDENT PeriodTbl;

DROP TABLE PeriodTbl;

Thanks,

James

Re: How this script works for creating period ?

sunny_talwar — Tue, 04 Oct 2016 11:19:16 GMT

You don't understand the code or is there a problem in the code you are trying to resolve?

Re: How this script works for creating period ?

fvelascog72 — Tue, 04 Oct 2016 11:21:20 GMT

Read this:

The As-Of Table

Re: How this script works for creating period ?

Tue, 04 Oct 2016 11:22:26 GMT

I am not able to understand the code and how this will generate the table. Like what will be the sample data.

topic Re: How this script works for creating period ? in QlikView

How this script works for creating period ?

Re: How this script works for creating period ?

Re: How this script works for creating period ?

Re: How this script works for creating period ?