Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

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

7 Replies
MVP
MVP

Re: How to create master calendar in Qlik Sense

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

jyothish8807
Honored Contributor II

Re: How to create master calendar in Qlik Sense

Hi Vidas,

Please go through this.

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

Regards

KC

Best Regards,
KC
mountaindude
Contributor III

Re: How to create master calendar in Qlik Sense

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.

markodonovan
Valued Contributor

Re: How to create master calendar in Qlik Sense

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

MVP
MVP

Re: How to create master calendar in Qlik Sense

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.

MVP
MVP

Re: How to create master calendar in Qlik Sense

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
New Contributor II

Re: How to create master calendar in Qlik Sense

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;

Community Browser