topic Re: How to use master calender in data modelling in QlikView https://community.qlik.com/t5/QlikView/How-to-use-master-calender-in-data-modelling/m-p/694728#M1071937 <HTML><HEAD></HEAD><BODY><P>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...</P><P></P><P>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...</P><P></P><P>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)...</P><P></P><P>Hope this will make clear idea on using Master Calendar... You can also use the link provided by tresesco..</P></BODY></HTML> Mon, 18 Aug 2014 09:56:51 GMT MK_QSL 2014-08-18T09:56:51Z How to use master calender in data modelling https://community.qlik.com/t5/QlikView/How-to-use-master-calender-in-data-modelling/m-p/694726#M1071934 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>How to use master calender in Qlikview</P></BODY></HTML> Mon, 18 Aug 2014 09:36:55 GMT https://community.qlik.com/t5/QlikView/How-to-use-master-calender-in-data-modelling/m-p/694726#M1071934 2014-08-18T09:36:55Z Re: How to use master calender in data modelling https://community.qlik.com/t5/QlikView/How-to-use-master-calender-in-data-modelling/m-p/694727#M1071935 <HTML><HEAD></HEAD><BODY><P>Check this blog post: <A _jive_internal="true" href="https://community.qlik.com/blogs/qlikviewdesignblog/2012/10/16/the-master-calendar" title="http://community.qlik.com/blogs/qlikviewdesignblog/2012/10/16/the-master-calendar">the-master-calendar</A></P></BODY></HTML> Mon, 18 Aug 2014 09:41:22 GMT https://community.qlik.com/t5/QlikView/How-to-use-master-calender-in-data-modelling/m-p/694727#M1071935 tresB 2014-08-18T09:41:22Z Re: How to use master calender in data modelling https://community.qlik.com/t5/QlikView/How-to-use-master-calender-in-data-modelling/m-p/694728#M1071937 <HTML><HEAD></HEAD><BODY><P>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...</P><P></P><P>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...</P><P></P><P>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)...</P><P></P><P>Hope this will make clear idea on using Master Calendar... You can also use the link provided by tresesco..</P></BODY></HTML> Mon, 18 Aug 2014 09:56:51 GMT https://community.qlik.com/t5/QlikView/How-to-use-master-calender-in-data-modelling/m-p/694728#M1071937 MK_QSL 2014-08-18T09:56:51Z Re: How to use master calender in data modelling https://community.qlik.com/t5/QlikView/How-to-use-master-calender-in-data-modelling/m-p/694729#M1071938 <HTML><HEAD></HEAD><BODY><P>Hi Venu</P><P></P><P>please see below link for the further information in regards to your query</P><P></P><P><A href="http://www.learnallbi.com/data-modeling-in-qlikview-part-1/" title="http://www.learnallbi.com/data-modeling-in-qlikview-part-1/">http://www.learnallbi.com/data-modeling-in-qlikview-part-1/</A></P><P></P><P></P><P><A _jive_internal="true" href="https://community.qlik.com/blogs/qlikviewdesignblog/2012/08/30/master-table-with-multiple-roles" title="http://community.qlik.com/blogs/qlikviewdesignblog/2012/08/30/master-table-with-multiple-roles">http://community.qlik.com/blogs/qlikviewdesignblog/2012/08/30/master-table-with-multiple-roles</A></P></BODY></HTML> Mon, 18 Aug 2014 09:57:13 GMT https://community.qlik.com/t5/QlikView/How-to-use-master-calender-in-data-modelling/m-p/694729#M1071938 2014-08-18T09:57:13Z