topic Re: Master Calendar in QlikView

Master Calendar

Wed, 30 Dec 2015 10:09:27 GMT

Hi Experts,

Can someone help me how to create Master calendar for the attached data

Thanks in Advance

Re: Master Calendar

Chanty4u — Wed, 30 Dec 2015 10:15:06 GMT

hi,

by usng dis u can create..please chk below thread

https://community.qlik.com/message/685476#685476

Re: Master Calendar

Wed, 30 Dec 2015 10:18:58 GMT

Master Calendar in QlikView | Learn QlikView‌

Master Calendar Generation Script

Re: Master Calendar

engishfaque — Wed, 30 Dec 2015 10:27:29 GMT

Dear Jack,

Kindly find attached Master Calendar.

Kind regards,

Ishfaque Ahmed

Re: Master Calendar

Wed, 30 Dec 2015 10:33:48 GMT

Hi,

Am using personal edition. Could you please paste the script

Thank you,

Re: Master Calendar

HirisH_V7 — Wed, 30 Dec 2015 10:50:47 GMT

Hi,

Check this ,

https://community.qlik.com/docs/DOC-12743

For better Perfromance.

Hope this helps.

Hirish

Re: Master Calendar

Wed, 30 Dec 2015 12:02:22 GMT

Hi,

Name the excel file load as T1 (shown in below image)

and paste following code in Script:

QuartersMap:

MAPPING LOAD

rowno() as Month,

'Q' & Ceil (rowno()/3) as Quarter

AUTOGENERATE (12);

Temp:

Load

min([Start Date]) as minDate,

max([End Date]) as maxDate

Resident T1;

Let varMinDate = Num(Peek('minDate', 0, 'Temp'));

Let varMaxDate = Num(Peek('maxDate', 0, 'Temp'));

DROP Table Temp;

TempCalendar:

LOAD

$(varMinDate) + Iterno()-1 As Num,

Date($(varMinDate) + IterNo() - 1) as TempDate

AutoGenerate 1 While $(varMinDate) + IterNo() -1 <= $(varMaxDate);

MasterCalendar:

Load

TempDate AS OrderDate,

week(TempDate) As Week,

Year(TempDate) As Year,

Month(TempDate) As Month,

Day(TempDate) As Day,

YeartoDate(TempDate)*-1 as CurYTDFlag,

YeartoDate(TempDate,-1)*-1 as LastYTDFlag,

inyear(TempDate, Monthstart($(varMaxDate)),-1) as RC12,

date(monthstart(TempDate), 'MMM-YYYY') as MonthYear,

ApplyMap('QuartersMap', month(TempDate), Null()) as Quarter,

Week(weekstart(TempDate)) & '-' & WeekYear(TempDate) as WeekYear,

WeekDay(TempDate) as WeekDay

Resident TempCalendar

Order By TempDate ASC;

Drop Table TempCalendar;

Regards,

Re: Master Calendar

Wed, 30 Dec 2015 12:04:56 GMT

PFA.

Re: Master Calendar

prma7799 — Wed, 30 Dec 2015 12:40:00 GMT

Please see

Creating A Master Calendar

Re: Master Calendar

MarcoWedel — Thu, 31 Dec 2015 02:25:21 GMT

Hi,

another calendar script:

tabCalendar: 
LOAD *, 
    Day(Date) as Day, 
    WeekDay(Date) as WeekDay, 
    Week(Date) as Week, 
    WeekName(Date) as WeekName, 
    Month(Date) as Month, 
    MonthName(Date) as MonthName, 
    Dual('Q'&Ceil(Month(Date)/3),Ceil(Month(Date)/3)) as Quarter, 
    QuarterName(Date) as QuarterName, 
    Year(Date) as Year, 
    WeekYear(Date) as WeekYear;   
LOAD Date(MinDate+IterNo()-1) as Date 
While MinDate+IterNo()-1 <= MaxDate; 
LOAD Min([Start Date]) as MinDate, 
    Max([End Date]) as MaxDate 
Resident YourTable;

hope this helps

regards

Marco

Re: Master Calendar

Thu, 31 Dec 2015 04:48:06 GMT

Thanks Marco

Re: Master Calendar

jagan — Thu, 07 Jan 2016 08:25:29 GMT

Hi,

Check this link tooo

Master Calendar Generation Script

Regards,

Jagan.