Error Loading Calendar

Fri, 07 Oct 2016 15:52:36 GMT

Hello,

I am trying to load a calendar using script below. and I get the following error.

Error:

Field not found - <>

LOAD

FieldValue('Date', RecNo()) as datefield

AutoGenerate FieldValueCount('Date')

Script:

Calendar Routine

SUB CalendarFromField(_field, _calendar, _prefix)

[$(_calendar)]:

// Generate Final Calendar

LOAD

[$(_field)]

,year([$(_field)]) as [$(_prefix)Year]

,month([$(_field)]) as [$(_prefix)Month]

,day([$(_field)]) as [$(_prefix)Day]

,weekday([$(_field)]) as [$(_prefix)Weekday]

,'Q'& ceil(Num(month([$(_field)]))/3) as [$(_prefix)Quarter]

;

// Generate range of dates between min and max.

LOAD

date(DateMin + IterNo()) as [$(_field)] // Link Field

WHILE DateMin + IterNo() <= DateMax

;

// Find min and max of date field values.

LOAD

min(datefield)-1 as DateMin

,max(datefield) as DateMax

;

// Load date field values.

LOAD

FieldValue('$(_field)', RecNo()) as datefield

AutoGenerate FieldValueCount('$(_field)');

END SUB

DateLink:

LOAD

N°Ticket

,[Inc Date Creation YYYY MM DD] as Date

,'openticket' as DateType

Resident OpenTickets;

LOAD

N°Ticket

,IncDateSolving as Date

,'closedticket' as DateType

Resident ClosedTickets;

CALL CalendarFromField('Date', 'MasterCalendar', '');

Re: Error Loading Calendar

el_aprendiz111 — Sat, 08 Oct 2016 17:51:00 GMT

Hi,

topic Error Loading Calendar in QlikView

Error Loading Calendar

Re: Error Loading Calendar