Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Showing results for 
Search instead for 
Did you mean: 

What is the use of Master Calendar ? give me an example

Hi All

I am new to Qlikview

What is the use of Master Calendar give me an example 

please help.

Labels (1)
2 Replies
Specialist II
Specialist II

Master Calendar , has its own need based on the data and the requirements in hand, few examples are:

1. You need to create the missing date for instance , if you are dealing with Sales data and a product has no sales on a particular date then that date will not have an entry in the table,  so now in case you want to display on which dates there were no sales of this product , you cannot do so without generating the missing dates using a Master Calendar

2. Supposedly you want dates starting from the first order that got placed til the last order that got delivered both of which are from different tables, Master Calendar comes handy

3. In case you need to create a Fiscal Calendar

So the use cases of a Master Calendar depends on your need


Support (Former)
Support (Former)

Please see the following Design Blog post, should explain everything quite well:


Please be sure to close out your threads too by using the Accept as Solution button on the post(s) that helped, or post your final comments and mark those so other Members will know what you did with things.

Here is the base Design Blog link which I think I have provided previously, please be sure to search there as there are over 700 posts in that area and most are how-to related, so should be very informative for you.



To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.