Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
how to create a master calender in qlik view?
Thanks
Have a loko at below:
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
thanks Aaron for your help.
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;