Qlik Community

Ask a Question

New to QlikView

If you’re new to QlikView, start with this Discussion Board and get up-to-speed quickly.

Announcements
Qlik Highlights 2020 Giveaway! Watch, reply and have a chance to win a $200 Amazon Gift Card! Watch Video
cancel
Showing results for 
Search instead for 
Did you mean: 
Creator III
Creator III

Master Calender

Hello

I come to know for what purpose we used master calendar ?(Ask in interview)

Thank You..

7 Replies
Master II
Master II

Hi,

Master calendar is a dimensional table and date join with the fact table (OrderDate, Purchase date etc)

we can use same Calendar for multiple Fact table dates & also it's used analyse non-captured fact table date

master calendar very is useful for create time series, Period rolling, comparative analysis

also check this,

Re: Use of Master Calendar

Hope this helps you

Thanks,
Deva

Specialist II
Specialist II

Hi,

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 a scenario, we create a Master Calendar which will supply the additional date fields like Quarter, Day etc. as required by any data set.

Master Calendar Generation Script

Hope it helps!!

Specialist II
Specialist II

In any Dashboard,Time is an important factor. Users will always be interested in viewing the data by time period and also will be interested in performing comparitive analysis between 2 time periods.

Master
Master

Hi Prachi,

I recommend reading attached file (including on page 5 about the master calendar).

Regards,

Andrey

Creator III
Creator III

How to create calendar to show daily sales compare to previous sale,if you don't have previous data  ?

Specialist II
Specialist II

If you dont have previous data you can show dates but values will be null

Master
Master

This is a joke?