If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
I expect you would use the same script as creating a calendar in Qlikview. There are many examples here in the community for Qlikview.
Plenty of sample master calendars in this forum.
To prove the point of load script compatibility between QlikView and Qlik Sense, I've ported several different QV apps over to Sense. Works great, except for the data connectors that have to be changed to Sense's new syntax. That's a minor issue though.
I actually used a master calendar in a post earlier today to exemplify QlikView to Qlik Sense script portability, small world.
In this post I have attached a qvf file with a simple calendar table example.
Worth having a looking into using QDF which has a simple function to create calendar tables.
Please check below link for Master Calendar script
Script is common to both Qlikview and Qliksense, so you can use the same script for Qliksense also.
RowNo() as Month,
'Q' & Ceil(RowNo()/3)as Quarter
RowNo() as Month,
'HY' & ceil(RowNo()/6) as HalfYear
Min(Opendate) as Mindate,
Max(Opendate) as Maxdate
LET vmindate= Num(Peek('Mindate',0,'Temp'));
LET vmaxdate= Num(Peek('Maxdate',0,'Temp'));
DROP Table Temp;
$(vmindate) + IterNo() -1 as Num,
Date($(vmindate) + IterNo() -1) as Date
($(vmindate) + IterNo() -1)<= $(vmaxdate);
Floor(Date) as Opendate,
Year(Date) as Year,
ApplyMap('Quartersmap',Month(Date),Null()) as Quarter,
ApplyMap('Halfyearsmap',Month(Date),Null()) as HalfYear,
Month(Date) as Month,
MonthName(Date) as MonthName,
Day(Date) as Day,
YearToDate(Date) as YTD,
Week(Date) as Week
DROP Table Calendar;
Sorry for necro, but how do I map several date fields on that calendar ?
For example I have opening_date, closing_date, modified_date fields ; how do I use the master calendar to map them ?