Loop Fields

Mon, 19 Dec 2011 12:26:03 GMT

Managed to create a master calendar but i get loop..any help would be appreciated.

See the attached for the datamodel

My script for this looks like:

let vStartDate= num(MakeDate(2010));

cal1:

load Date($(vStartDate)+RowNo()-1) as Date

AutoGenerate(num(today())- $(vStartDate)+1);

cal2:

load

year(Date) as [Year],

Month(Date) as [Month],

Day(Date) as Day,

dual((Month(Date) &'-'&Year(Date)),num(MakeDate(year(Date),month(Date)))) as Monthyear

Resident cal1;

drop table cal1;

CalendarLinkage:

LOAD

%InvoiceBillingDocument_Key,

'Open Date' as DataType,

Date(DateValueSales) as Date//CalendarDate

FROM data\SAPMM\Projects\BSID_OpenItems_Header.qvd (qvd);

CONCATENATE (CalendarLinkage)

LOAD

%InvoiceBillingDocument_Key ,

'Close Date' as DataType,

Date(DateValueSales_C) as Date//CalendarDate

FROM data\SAPMM\Projects\BSAD_ClosedItems_Header.qvd (qvd);

CONCATENATE (CalendarLinkage)

LOAD

%KEY_BELNR_BUZEI_KOKRS_MANDT,

'COVP Date' as DataType,

Date([Posting Date]) as Date

From Data\SAPMM\Projects\COVP.qvd(Qvd) WHERE Year_Pur>2010 and Year_Pur<=Year(today()) and Month_Pur<NUM(Month(today(1)));

topic Loop Fields in QlikView