topic Re: Master calender in QlikView https://community.qlik.com/t5/QlikView/Master-calender/m-p/1172757#M908108 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #000000; font-family: Verdana, Geneva, Tahoma, Arial, Helvetica, sans-serif; font-size: 15px; text-align: justify;">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 scenario we create a </SPAN><SPAN style="color: #000000; font-family: Verdana, Geneva, Tahoma, Arial, Helvetica, sans-serif; font-size: 15px; text-align: justify;"> m<SPAN style="color: #000000; font-family: Verdana, Geneva, Tahoma, Arial, Helvetica, sans-serif; font-size: 15px; text-align: justify;">aster calendar w</SPAN>hich will supply the additional date fields like Quarter, Day etc as required by any data set.</SPAN></P></BODY></HTML> Wed, 22 Jun 2016 10:55:18 GMT sampada0810 2016-06-22T10:55:18Z Master calender https://community.qlik.com/t5/QlikView/Master-calender/m-p/1172751#M908102 <HTML><HEAD></HEAD><BODY><P>Hi Experts,</P><P></P><P></P><P>I don't have Date field in source. How can i&nbsp; create&nbsp; Master Calender.</P><P></P><P>Regards,</P><P>Mahesh</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Master-calender/m-p/1172751#M908102 qlikview979 2020-11-25T16:16:04Z Re: Master calender https://community.qlik.com/t5/QlikView/Master-calender/m-p/1172752#M908103 <HTML><HEAD></HEAD><BODY><P>What field you are having?</P></BODY></HTML> Wed, 22 Jun 2016 10:47:23 GMT https://community.qlik.com/t5/QlikView/Master-calender/m-p/1172752#M908103 MK_QSL 2016-06-22T10:47:23Z Re: Master calender https://community.qlik.com/t5/QlikView/Master-calender/m-p/1172753#M908104 <HTML><HEAD></HEAD><BODY><P>Hi Manish,</P><P></P><P>I want to learn about Master Calender . What purpose&nbsp; we need to use&nbsp; master calender? what is the use?can you share with Example?</P><P></P><P>Regards</P></BODY></HTML> Wed, 22 Jun 2016 10:50:41 GMT https://community.qlik.com/t5/QlikView/Master-calender/m-p/1172753#M908104 qlikview979 2016-06-22T10:50:41Z Re: Master calender https://community.qlik.com/t5/QlikView/Master-calender/m-p/1172754#M908105 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Can you send me sample app?</P></BODY></HTML> Wed, 22 Jun 2016 10:51:22 GMT https://community.qlik.com/t5/QlikView/Master-calender/m-p/1172754#M908105 muthukumar77 2016-06-22T10:51:22Z Re: Master calender https://community.qlik.com/t5/QlikView/Master-calender/m-p/1172755#M908106 <HTML><HEAD></HEAD><BODY><P>You must be having some id or a key not necessarily in date format. You can use that.</P><P>Here's a script to create a master calender.</P></BODY></HTML> Wed, 22 Jun 2016 10:53:14 GMT https://community.qlik.com/t5/QlikView/Master-calender/m-p/1172755#M908106 sampada0810 2016-06-22T10:53:14Z Re: Master calender https://community.qlik.com/t5/QlikView/Master-calender/m-p/1172756#M908107 <HTML><HEAD></HEAD><BODY><P>Hi Muthukumar,</P><P></P><P>Hope these thread will help you out.</P><P></P><P><A href="https://community.qlik.com/docs/DOC-8843">How to use - Master-Calendar and Date-Values</A></P><P></P><P><A href="https://community.qlik.com/thread/48693">Creating A Master Calendar</A></P></BODY></HTML> Wed, 22 Jun 2016 10:54:37 GMT https://community.qlik.com/t5/QlikView/Master-calender/m-p/1172756#M908107 bindu_apte 2016-06-22T10:54:37Z Re: Master calender https://community.qlik.com/t5/QlikView/Master-calender/m-p/1172757#M908108 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #000000; font-family: Verdana, Geneva, Tahoma, Arial, Helvetica, sans-serif; font-size: 15px; text-align: justify;">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 scenario we create a </SPAN><SPAN style="color: #000000; font-family: Verdana, Geneva, Tahoma, Arial, Helvetica, sans-serif; font-size: 15px; text-align: justify;"> m<SPAN style="color: #000000; font-family: Verdana, Geneva, Tahoma, Arial, Helvetica, sans-serif; font-size: 15px; text-align: justify;">aster calendar w</SPAN>hich will supply the additional date fields like Quarter, Day etc as required by any data set.</SPAN></P></BODY></HTML> Wed, 22 Jun 2016 10:55:18 GMT https://community.qlik.com/t5/QlikView/Master-calender/m-p/1172757#M908108 sampada0810 2016-06-22T10:55:18Z Re: Master calender https://community.qlik.com/t5/QlikView/Master-calender/m-p/1172758#M908109 <HTML><HEAD></HEAD><BODY><P>have a look at attached file.</P><P></P><P>hope this helps</P></BODY></HTML> Wed, 22 Jun 2016 10:56:34 GMT https://community.qlik.com/t5/QlikView/Master-calender/m-p/1172758#M908109 Frank_Hartmann 2016-06-22T10:56:34Z Re: Master calender https://community.qlik.com/t5/QlikView/Master-calender/m-p/1172759#M908110 <HTML><HEAD></HEAD><BODY><P>Hi Mahesh,</P><P></P><P>Try this</P><P><A href="https://community.qlik.com/docs/DOC-1310">How to create a Calendar</A></P><P></P><P>Regards</P><P></P><P>Miguel del Valle</P></BODY></HTML> Wed, 22 Jun 2016 11:02:35 GMT https://community.qlik.com/t5/QlikView/Master-calender/m-p/1172759#M908110 migueldelval 2016-06-22T11:02:35Z Re: Master calender https://community.qlik.com/t5/QlikView/Master-calender/m-p/1172760#M908111 <HTML><HEAD></HEAD><BODY><P>In that case, you will find 100s of blogs and questions related to master calendar, fiscal calendar, canonical calendar etc.</P><P>try to spend some time on community search and let us know if you don't know some specific blog or question/answer.</P></BODY></HTML> Wed, 22 Jun 2016 11:14:18 GMT https://community.qlik.com/t5/QlikView/Master-calender/m-p/1172760#M908111 MK_QSL 2016-06-22T11:14:18Z Re: Master calender https://community.qlik.com/t5/QlikView/Master-calender/m-p/1172761#M908112 <HTML><HEAD></HEAD><BODY><P>Hi Bindu Apte,</P><P></P><P>Question is not raised by me. That is Mahesh Kumar.</P></BODY></HTML> Wed, 22 Jun 2016 12:29:02 GMT https://community.qlik.com/t5/QlikView/Master-calender/m-p/1172761#M908112 muthukumar77 2016-06-22T12:29:02Z Re: Master calender https://community.qlik.com/t5/QlikView/Master-calender/m-p/1172762#M908113 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 13.3333px;">Hi, </SPAN><SPAN lang="en" style="font-size: 13.3333px;">This file can help you.</SPAN></P></BODY></HTML> Wed, 22 Jun 2016 19:57:24 GMT https://community.qlik.com/t5/QlikView/Master-calender/m-p/1172762#M908113 2016-06-22T19:57:24Z