topic Re: Master Calendar Setup in QlikView

Master Calendar Setup

Anonymous — Tue, 23 Apr 2013 07:03:05 GMT

I am wanting to get Master Calendar working in a file where I am just pulling through a date from a spreadsheet table.

I am getting the following error message -

Table not found

MasterCalendar:

LOAD

TempDate as Date,

Week(TempDate) As Week,

Year(TempDate) AS Year,

Month(TempDate) AS Month,

Day(TempDate) AS Day

RESIDENT TempCal

Can anyone help me to get this setup.

Re: Master Calendar Setup

Tue, 23 Apr 2013 08:19:24 GMT

Make sure that you have created the original TempCal load as a NoConcatenate LOAD and then do the same for this MasterCalendar load i.e.

MasterCalendar:

NoConcatenate LOAD

TempDate as Date,

Week(TempDate) As Week,

Year(TempDate) AS Year,

Month(TempDate) AS Month,

Day(TempDate) AS Day

RESIDENT TempCal

Re: Master Calendar Setup

er_mohit — Tue, 23 Apr 2013 08:50:15 GMT

Try this

LET vDateMin = Num(MakeDate(2006,1,1));

LET vDateMax = Floor(DayEnd(Today()));

LET vDateToday = Num(Today());

TempCalendar:

LOAD

date($(vDateMin) + RowNo() -1) AS DateNumber ,

Date($(vDateMin) + RowNo() -1) AS TempDate ,

Week(Today())+4

AUTOGENERATE 1

WHILE $(vDateMin)+IterNo()<= $(vDateMax);

LOAD

Day(TempDate) AS CalendarDayOfMonth,

YearName(TempDate,0,2)as FiscalYear,

Year(TempDate) AS YTD,

Month(TempDate) AS CalendarMonthName,

'Q' & Ceil(Month(TempDate)/3) AS CalendarQuarter,

MonthStart(TempDate) as CalendarMonthStart,

QuarterStart(TempDate) as CalendarQuarterStart,

num(month(TempDate))as num_month,

YearStart(TempDate) as CalendarYearStart,

MonthEnd(TempDate) as LMTD,

QuarterEnd(TempDate) as LQTD,

(Date#(TempDate,'DD-MM-YYYY'))as Current_date,

YearEnd(TempDate) as LYTD

RESIDENT TempCalendar ORDER BY TempDate ASC;

Re: Master Calendar Setup

Tue, 23 Apr 2013 09:49:50 GMT

Hi ,

Please check if name of the previouesly loaded Spreadsheet is "TempCal" and name of the table are of same case.

If not please attach work file or paste you complete script