topic Inline table Calendar in QlikView

Inline table Calendar

shanky1907 — Tue, 19 Aug 2014 10:20:29 GMT

Hi,

I want to generate an inline table using qv script such that the table contains fields as Year, Month, Quarter, Week and Day Along with the full Date.

Please help me regarding the matter.

Re: Inline table Calendar

ashfaq_haseeb — Tue, 19 Aug 2014 10:43:53 GMT

Hi,

Look at below code:

Let varMinDate = num(MakeDate(2000,1,1));

Let varMaxDate = num(MakeDate(2020,12,31));

//*************** Temporary Calendar ***************

TempCalendar:

LOAD

$(varMinDate) + rowno() - 1 AS Num,

date($(varMinDate) + rowno() - 1) AS TempDate

AUTOGENERATE

$(varMaxDate) - $(varMinDate) + 1;

//*************** Master Calendar ***************

MasterCalendar:

LOAD TempDate AS Date,

Week(TempDate) AS Week,

WeekYear(TempDate) as TestWeek,

Year(TempDate) AS Year,

Month(TempDate) AS Month,

year(TempDate)&'-'&Month(TempDate) as Year_Month,

MonthName(TempDate) as YearMonth,

Day(TempDate) AS Day,

'Q'&ceil(month(TempDate)/3) AS Quarter

RESIDENT TempCalendar

ORDER BY TempDate ASC;

DROP TABLE TempCalendar;

Store MasterCalendar into MasterCalendar.qvd(qvd);

Regards

ASHFAQ

Re: Inline table Calendar

ecolomer — Tue, 19 Aug 2014 10:48:47 GMT

Here you are an example

Re: Inline table Calendar

Anonymous — Tue, 19 Aug 2014 10:49:15 GMT

vMinDate=Floor(MakeDate(2013));
Let vMaxDate=Floor(MakeDate(2013,10,31));
Let vNumDays=vMaxDate-vMinDate+1;

Calendar:

Load
TempDate as DateID,
Date(TempDate) As Date,
Year(TempDate) As Year,
Month(TempDate) As Month,
Date(MonthStart(TempDate), 'YYYY/MM') As YearMonth;

Load
RecNo()-1+$(vMinDate) As TempDate
AutoGenerate($(vNumDays));

Re: Inline table Calendar

Tue, 19 Aug 2014 11:19:56 GMT

In addition to the above posts, you can also refer to Qlikview 11 developers Book and Qlikview Cookbook by Rob Wonderlich which has got additional Features in Master Calendar Creation

-Ram