Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
How to use master calender in Qlikview
Check this blog post: the-master-calendar
Master Calendar is used for the Date Fields... The purpose is to fill the gapes where there are no data and transactions for any particular date...
The base is Minimum Date and Maximum Date of your data model... By using the Loop, we can have All Dates from Minimum Date to Maximum Date...
Now using these dates, we can have Week, WeekDays, Month, Year, Quarter, MonthYear, YearMonth etc as a separate calendar table which is associated with the main/fact table with the Date field.. (same name)...
Hope this will make clear idea on using Master Calendar... You can also use the link provided by tresesco..
Hi Venu
please see below link for the further information in regards to your query
http://www.learnallbi.com/data-modeling-in-qlikview-part-1/
http://community.qlik.com/blogs/qlikviewdesignblog/2012/08/30/master-table-with-multiple-roles