topic Re: Master calendar in QlikView

Master calendar

Mon, 16 Jun 2014 06:29:16 GMT

Hi all

How can i create master calendar, if i have onlly this data? i need year, yearmonth dimensions.

ashfaq_haseeb — Mon, 16 Jun 2014 06:38:02 GMT

Hi,

Use the below code.

Directory;

LOAD Period,

Date(Date#(Period,'MMM YYYY')) as Date,

year(Date#(Period,'MMM YYYY')) as Year,

MonthName(Date#(Period,'MMM YYYY')) as Month_Year

FROM

Calendar.xlsx

(ooxml, embedded labels, table is Sheet1);

Regards

ASHFAQ

its_anandrjs — Mon, 16 Jun 2014 06:42:46 GMT

Create another master calendar table see the load script

Source:

LOAD

Period

FROM

Calendar.xlsx

(ooxml, embedded labels, table is Sheet1);

MasaterCalendar:

LOAD

Period,

Year(Date#(Right(Period,4),'YYYY')) as Year,

Month(Date#(Capitalize(Left(Period,3)),'MMM')) as Month,

MonthName(MakeDate(Year(Date#(Right(Period,4),'YYYY')), Month(Date#(Capitalize(Left(Period,3)),'MMM')))) AS MonthYear

Resident Source;

Mon, 16 Jun 2014 06:58:41 GMT

Thanks!!