Skip to main content
Announcements
Global Transformation Awards! Applications are now open. Submit Entry
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Hi, Can any one please answer my doubts about master calendar and calendar object?

We have already a feature calender object in Qlikview.But what is the use of master calender creations?

What is the difference between these two?

Regards,

Deepthi

3 Replies
sujeetsingh
Master III
Master III

Raj,

A calender object is used to present the date from the calender means it requires field to be called in calender object.

While Master calender is the one which is created from a date field and contains all the entities of a calender like Week day .month etc.

For example there be sales date 01-03-2011 to 23-09-2013

Now the logic of master calender takes the mindate() and maxdate() and the the script creates the complete calender between the max date and min date.

Go to these links

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

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

Gysbert_Wassenaar

See this blog post: Why You sometimes should Load a Master Table several times

And this discussion: Tutorial - Using Common Date Dimensions and Shared Calendars


talk is cheap, supply exceeds demand
Not applicable
Author

My question is which is the best case to use calendar?

In calendar object also we have vFromdate and Vtodate and master calendar contains maxDate() and minDate().

In which cases we have go for these different calenders?

Regards,

Deepthi