Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi ...
can any one help me how to create Date dimension in Qlikview?
Thanks & Regards,
Chandini.G
Hi,
have a look at below post.
Let varMinDate = num(MakeDate(2000,1,1));
Let varMaxDate = num(MakeDate(2020,12,31));
//*************** Temporary Calendar ***************
TempCalendar:
LOAD
$(varMinDate) + rowno() - 1 AS Num,
date($(varMinDate) + rowno() - 1) AS TempDate
AUTOGENERATE
$(varMaxDate) - $(varMinDate) + 1;
//*************** Master Calendar ***************
MasterCalendar:
LOAD TempDate AS Date,
Week(TempDate) AS Week,
WeekYear(TempDate) as TestWeek,
Year(TempDate) AS Year,
Month(TempDate) AS Month,
year(TempDate)&'-'&Month(TempDate) as Year_Month,
MonthName(TempDate) as YearMonth,
Day(TempDate) AS Day,
'Q'&ceil(month(TempDate)/3) AS Quarter
RESIDENT TempCalendar
ORDER BY TempDate ASC;
DROP TABLE TempCalendar;
Store MasterCalendar into MasterCalendar.qvd(qvd);
Regards
ASHFAQ
PFA master Calender script.
there are alrwady a lot of useful post in the community about master calendar, some of them
Re: i want create master calendar ? how to create ?pls give some small example and explination?
http://community.qlik.com/blogs/qlikviewdesignblog/2012/10/16/the-master-calendar