Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hai
Master Calendar is a quite frequent topic in the community. I would suggest that you use the search option and look at the previous blog posts, questions and documents. If these does not clear enough, then post a question to specify what part you are stuck on.
It is a logical table often created in qlikview data model, containing dates in a variety of formats - date, month,quarter, year, week, etc.
Look here for more
Hi,
another script that creates a calender table out of a previously loaded table containing the field "Date":
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(Date) as MinDate,
Max(Date) as MaxDate
Resident tabSourceOfDate;
hope this helps
regards
Marco
Master Calendar is a quite frequent topic in the community. I would suggest that you use the search option and look at the previous blog posts, questions and documents. If these does not clear enough, then post a question to specify what part you are stuck on.
Have you ever searched in community before posting here ??