topic Re: master calender in qlik view in QlikView

master calender in qlik view

Thu, 05 Feb 2015 08:40:46 GMT

Hi all,

how to create a master calender in qlik view?

Thanks

Re: master calender in qlik view

jpenuliar — Thu, 05 Feb 2015 08:42:16 GMT

Have a loko at below:

The Master Calendar

Re: master calender in qlik view

morganaaron — Thu, 05 Feb 2015 08:49:30 GMT

Hi Vikram,

I notice you're posting a lot of questions on the basic fundamentals of Qlikview - there's loads of information available when you're new to Qlikview, including free training from Qlik themselves (see http://www.qlik.com/us/services/training/free-training) - as well as there being a wealth of information on the community. Try searching for your topic first to see if it's been answered before - and consider buying a manual to Qlik (like Qlikview 11 for Developers or Qlikview for Developers Cookbook) if you want to grasp a knowledge of everything that's involved!

If you still have questions however, feel free to ask them here - but if you need a broader understanding try those sources first

Re: master calender in qlik view

Thu, 05 Feb 2015 08:51:43 GMT

thanks Aaron for your help.

Re: master calender in qlik view

prma7799 — Thu, 05 Feb 2015 08:53:24 GMT

Quarter_Map:
Mapping
LOAD * INLINE [
Month, Quarter
Jan, Q1
Feb, Q1
Mar, Q1
Apr, Q2
May, Q2
Jun, Q2
Jul, Q3
Aug, Q3
Sep, Q3
Oct, Q4
Nov, Q4
Dec, Q4
];

///////////////////////////////////////

Temp:
load
min([Business Date1]) as MinDate,
max([Business Date1]) as MaxDate
Resident Coll_Report;

let vDateMin=num(date(peek('MinDate',0,'Temp')));
let vDateMax=num(date(peek('MaxDate',1,'temp')));

LET vDateMin = Num(Peek('Open_DateTime', 0, 'Interval_Table'));
LET vDateMax = Num(Peek('Close_DateTime', -1, 'Interval_Table'));
LET vDateToday = Num(Today());

TempCalendar1:
LOAD
$(vDateMin) + RowNo() - 1 AS Date_Key,
Date($(vDateMin) + RowNo() - 1) AS Date
AUTOGENERATE 1
WHILE $(vDateMin)+IterNo()-1<= $(vDateMax);

Master_Calendar:
load Date_Key
//,Date as [Business Date1]
,Date as CalendarDate
,Date as [Start Date]
,Day(Date) as CalendarDay
// ,Week(Date) as CalendarWeek
// ,WeekName(Date) as CalendarWeekName
,month(Date) as CalendarMonth
,MonthName(Date) as CalendarMonthName
// ,MonthName(Date) as CalendarPeriod
,Quartername(Date) as CalendarQuarterName
,ApplyMap('Quarter_Map',num#(month(Date)))as CalendarQuarter
,year(Date) as CalendarYear
// ,WeekDay(Date) as CalendarWeekDay
// ,text(weekday(Date)) as Week_Day1

,WeekDay(Date) as CalWeekDay
,Week(Date) as CalWeek
,week(Date+3) as CalRWeek
,WeekName(Date) as CalWeekName
,WeekName(Date,1,4) as CalWeekRName //4=Fri // Friday - Thursday Business Week
,MakeWeekDate(Year(Date),Week(Date)) as CalWkSD
,num(MakeWeekDate(Year(Date),Week(Date))) as CalWkSDNum
,MakeWeekDate(Year(Date+3),Week(Date+3),-3) as CalWkRSD
,num(MakeWeekDate(Year(Date+3),Week(Date+3),-3)) as CalWkRSDNum

Resident TempCalendar1;
DROP Table TempCalendar1;

Re: master calender in qlik view

prma7799 — Thu, 05 Feb 2015 08:55:51 GMT

http://community.qlik.com/message/669789#669789

Re: master calender in qlik view

jagan — Thu, 05 Feb 2015 08:56:28 GMT

Hi,

Check this link

Master Calendar Generation Script

Regards,

Jagan.