Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Specialist
Specialist

Master calender

Hi Experts,

I don't have Date field in source. How can i  create  Master Calender.

Regards,

Mahesh

1 Solution

Accepted Solutions
Highlighted
Creator III
Creator III

Re: Master calender

11 Replies
Highlighted
MVP
MVP

Re: Master calender

What field you are having?

Highlighted
Specialist
Specialist

Re: Master calender

Hi Manish,

I want to learn about Master Calender . What purpose  we need to use  master calender? what is the use?can you share with Example?

Regards

Highlighted
Partner
Partner

Re: Master calender

Hi,

Can you send me sample app?

Muthukumar Pandiyan
Highlighted
Creator
Creator

Re: Master calender

You must be having some id or a key not necessarily in date format. You can use that.

Here's a script to create a master calender.

Highlighted
Creator III
Creator III

Re: Master calender

Highlighted
Creator
Creator

Re: Master calender

In QlikView, many times we need to create a calendar reference object which can be linked to any data set present in QlikView's memory. For example you have a table that captures the sales amount and sales date but does not store the weekday or quarter which corresponds to that date. In such scenario we create a master calendar which will supply the additional date fields like Quarter, Day etc as required by any data set.

Highlighted
Master II
Master II

Re: Master calender

have a look at attached file.

hope this helps

Highlighted
Specialist
Specialist

Re: Master calender

Hi Mahesh,

Try this

How to create a Calendar

Regards

Miguel del Valle

Highlighted
MVP
MVP

Re: Master calender

In that case, you will find 100s of blogs and questions related to master calendar, fiscal calendar, canonical calendar etc.

try to spend some time on community search and let us know if you don't know some specific blog or question/answer.