topic Re: Creating Master Calendar in App Development https://community.qlik.com/t5/App-Development/Creating-Master-Calendar/m-p/1418671#M33605 <HTML><HEAD></HEAD><BODY><P>Hi Shinge</P><P></P><P>If you use the data maneger to prep the data, Qlik Sense will automatic generate a usable calender base on derived fields</P><P></P><P>/Teis</P></BODY></HTML> Mon, 04 Dec 2017 14:52:11 GMT teiswamsler 2017-12-04T14:52:11Z Creating Master Calendar https://community.qlik.com/t5/App-Development/Creating-Master-Calendar/m-p/1418669#M33603 <HTML><HEAD></HEAD><BODY><P>Hello Guys, </P><P></P><P>I have to create a master calendar .</P><P>I have around 200 different projects with unique ids which has :- </P><P>a. Start date</P><P>b. End date </P><P></P><P>I have to create a master calendar using auto generate . Kindly help me with this .</P><P></P><P>My tables looks like this as shown below :- </P><TABLE border="1" class="jiveBorder" height="99" style="border: 1px solid rgb(0, 0, 0); width: 528px; height: 99px;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>ID Project</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Start date<SPAN style="font-size: 13.3333px;">(MMDDYYYY)</SPAN></STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>End Date<SPAN style="font-size: 13.3333px;">(MMDDYYYY)</SPAN></STRONG></TH></TR><TR><TD style="padding: 2px;">12</TD><TD style="padding: 2px;">02/02/2015 </TD><TD style="padding: 2px;">20/06/2019</TD></TR><TR><TD style="padding: 2px;">34</TD><TD style="padding: 2px;">30/07/2016</TD><TD style="padding: 2px;">04/05/2018</TD></TR><TR><TD style="padding: 2px;">56</TD><TD style="padding: 2px;">26/04/2016</TD><TD style="padding: 2px;">06/07/2019</TD></TR></TBODY></TABLE><P></P><P>Along with master calendar , I also need to calculate <SPAN style="font-size: 10pt;">difference between these two dates(End-Start) in months, days, years and so on.....</SPAN></P><P></P><P>Thanks In Advance,</P><P>ravi </P></BODY></HTML> Mon, 04 Dec 2017 12:43:45 GMT https://community.qlik.com/t5/App-Development/Creating-Master-Calendar/m-p/1418669#M33603 Anonymous 2017-12-04T12:43:45Z Re: Creating Master Calendar https://community.qlik.com/t5/App-Development/Creating-Master-Calendar/m-p/1418670#M33604 <HTML><HEAD></HEAD><BODY><P>Refer <A href="https://community.qlik.com/thread/47114">capture dates in between start date and end date</A></P></BODY></HTML> Mon, 04 Dec 2017 14:45:47 GMT https://community.qlik.com/t5/App-Development/Creating-Master-Calendar/m-p/1418670#M33604 shraddha_g 2017-12-04T14:45:47Z Re: Creating Master Calendar https://community.qlik.com/t5/App-Development/Creating-Master-Calendar/m-p/1418671#M33605 <HTML><HEAD></HEAD><BODY><P>Hi Shinge</P><P></P><P>If you use the data maneger to prep the data, Qlik Sense will automatic generate a usable calender base on derived fields</P><P></P><P>/Teis</P></BODY></HTML> Mon, 04 Dec 2017 14:52:11 GMT https://community.qlik.com/t5/App-Development/Creating-Master-Calendar/m-p/1418671#M33605 teiswamsler 2017-12-04T14:52:11Z