Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to create master calendar in Qlik Sense

Hi all,

In discussions I could not find how to create master calendar in Qlik Sense.

Does anybody knows how to do this?

Thanks in advance.

Vidas

8 Replies
jonathandienst

Hi

I expect you would use the same script as creating a calendar in Qlikview. There are many examples here in the community for Qlikview.

HTH

Jonathan

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
jyothish8807
Master II
Master II

Hi Vidas,

Please go through this.

http://community.qlik.com/thread/48693

Regards

KC

Best Regards,
KC
mountaindude
Luminary Alumni
Luminary Alumni

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.

Please mark the post as a solution if it provided you with a solution to the topic at hand. Thanks!
markodonovan
Specialist
Specialist

HI Vidas,

In this post I have attached a qvf file with a simple calendar table example.

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

Worth having a looking into using QDF which has a simple function to create calendar tables.

Thanks

Mark

www.techstuffybooks.com

jagan
Luminary Alumni
Luminary Alumni

Hi,

Please check below link for Master Calendar script

Master Calendar Generation Script

Script is common to both Qlikview and Qliksense, so you can use the same script for Qliksense also.

Regards,

Jagan.

jagan
Luminary Alumni
Luminary Alumni

Hi,

If you got the answer please close this thread so that it would be helpful to others to easily find the solution.

Regards,

Jagan.

boraste-sagar
Contributor III
Contributor III

Quartersmap:
Mapping Load
RowNo() as Month,
'Q' &
Ceil(RowNo()/3)as Quarter
AutoGenerate (12);


Halfyearsmap:
Mapping Load
RowNo() as Month,
'HY' &
ceil(RowNo()/6) as HalfYear
AutoGenerate (12);


Temp:
LOAD
Min(Opendate) as Mindate,
Max(Opendate) as Maxdate
Resident Main;

LET vmindate= Num(Peek('Mindate',0,'Temp'));
LET vmaxdate= Num(Peek('Maxdate',0,'Temp'));

DROP Table Temp;

Calendar:
LOAD
$(vmindate) + IterNo() -1 as Num,
Date($(vmindate) + IterNo() -1) as Date
AutoGenerate 1
While
(
$(vmindate) + IterNo() -1)<= $(vmaxdate);

Master_Cal:
LOAD  
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
Resident Calendar;

DROP Table Calendar;

Saryk
Partner
Partner

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 ?