Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
qlikview979
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
11 Replies
MK_QSL
MVP
MVP

What field you are having?

qlikview979
Specialist
Specialist
Author

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

muthukumar77
Partner - Creator III
Partner - Creator III

Hi,

Can you send me sample app?

Muthukumar Pandiyan
sampada0810
Creator
Creator

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.

bindu_apte
Creator III
Creator III

Hi Muthukumar,

Hope these thread will help you out.

How to use - Master-Calendar and Date-Values

Creating A Master Calendar

sampada0810
Creator
Creator

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.

Frank_Hartmann
Master II
Master II

have a look at attached file.

hope this helps

migueldelval
Specialist
Specialist

Hi Mahesh,

Try this

How to create a Calendar

Regards

Miguel del Valle

MK_QSL
MVP
MVP

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.