https://community.qlik.com/t5/App-Development/Create-Master-Calendar-With-5-4-4-Calendar/m-p/1821104#M67308 <P>Hi All,</P><P>I have to create one master calendar with 5-4-4 weeks the given below: For every quarter of the first month should have 5 weeks based on the start date and end date.</P><TABLE><TBODY><TR><TD>Start Date for the Month</TD><TD>End Date for the Month</TD><TD>Financial Year</TD><TD>Quarter#</TD><TD>Month#</TD></TR><TR><TD>28-09-2020</TD><TD>01-11-2020</TD><TD>FY2020-21</TD><TD>1</TD><TD>1</TD></TR><TR><TD>02-11-2020</TD><TD>29-11-2020</TD><TD>FY2020-21</TD><TD>1</TD><TD>2</TD></TR><TR><TD>30-11-2020</TD><TD>27-12-2020</TD><TD>FY2020-21</TD><TD>1</TD><TD>3</TD></TR><TR><TD>28-12-2020</TD><TD>31-01-2021</TD><TD>FY2020-21</TD><TD>2</TD><TD>4</TD></TR><TR><TD>01-02-2021</TD><TD>28-02-2021</TD><TD>FY2020-21</TD><TD>2</TD><TD>5</TD></TR><TR><TD>01-03-2021</TD><TD>28-03-2021</TD><TD>FY2020-21</TD><TD>2</TD><TD>6</TD></TR><TR><TD>29-03-2021</TD><TD>02-05-2021</TD><TD>FY2020-21</TD><TD>3</TD><TD>7</TD></TR><TR><TD>03-05-2021</TD><TD>30-05-2021</TD><TD>FY2020-21</TD><TD>3</TD><TD>8</TD></TR><TR><TD>31-05-2021</TD><TD>27-06-2021</TD><TD>FY2020-21</TD><TD>3</TD><TD>9</TD></TR><TR><TD>28-06-2021</TD><TD>01-08-2021</TD><TD>FY2020-21</TD><TD>4</TD><TD>10</TD></TR><TR><TD>02-08-2021</TD><TD>29-08-2021</TD><TD>FY2020-21</TD><TD>4</TD><TD>11</TD></TR><TR><TD>30-08-2021</TD><TD>26-09-2021</TD><TD>FY2020-21</TD><TD>4</TD><TD>12</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Kindly help me to create this.</P><P>Thanks in advance.</P><P>Regards,</P><P>Dinesh Kumar Mani.</P> Fri, 09 Jul 2021 15:38:47 GMT dineshm030 2021-07-09T15:38:47Z https://community.qlik.com/t5/App-Development/Create-Master-Calendar-With-5-4-4-Calendar/m-p/1821104#M67308 <P>Hi All,</P><P>I have to create one master calendar with 5-4-4 weeks the given below: For every quarter of the first month should have 5 weeks based on the start date and end date.</P><TABLE><TBODY><TR><TD>Start Date for the Month</TD><TD>End Date for the Month</TD><TD>Financial Year</TD><TD>Quarter#</TD><TD>Month#</TD></TR><TR><TD>28-09-2020</TD><TD>01-11-2020</TD><TD>FY2020-21</TD><TD>1</TD><TD>1</TD></TR><TR><TD>02-11-2020</TD><TD>29-11-2020</TD><TD>FY2020-21</TD><TD>1</TD><TD>2</TD></TR><TR><TD>30-11-2020</TD><TD>27-12-2020</TD><TD>FY2020-21</TD><TD>1</TD><TD>3</TD></TR><TR><TD>28-12-2020</TD><TD>31-01-2021</TD><TD>FY2020-21</TD><TD>2</TD><TD>4</TD></TR><TR><TD>01-02-2021</TD><TD>28-02-2021</TD><TD>FY2020-21</TD><TD>2</TD><TD>5</TD></TR><TR><TD>01-03-2021</TD><TD>28-03-2021</TD><TD>FY2020-21</TD><TD>2</TD><TD>6</TD></TR><TR><TD>29-03-2021</TD><TD>02-05-2021</TD><TD>FY2020-21</TD><TD>3</TD><TD>7</TD></TR><TR><TD>03-05-2021</TD><TD>30-05-2021</TD><TD>FY2020-21</TD><TD>3</TD><TD>8</TD></TR><TR><TD>31-05-2021</TD><TD>27-06-2021</TD><TD>FY2020-21</TD><TD>3</TD><TD>9</TD></TR><TR><TD>28-06-2021</TD><TD>01-08-2021</TD><TD>FY2020-21</TD><TD>4</TD><TD>10</TD></TR><TR><TD>02-08-2021</TD><TD>29-08-2021</TD><TD>FY2020-21</TD><TD>4</TD><TD>11</TD></TR><TR><TD>30-08-2021</TD><TD>26-09-2021</TD><TD>FY2020-21</TD><TD>4</TD><TD>12</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Kindly help me to create this.</P><P>Thanks in advance.</P><P>Regards,</P><P>Dinesh Kumar Mani.</P> Fri, 09 Jul 2021 15:38:47 GMT https://community.qlik.com/t5/App-Development/Create-Master-Calendar-With-5-4-4-Calendar/m-p/1821104#M67308 dineshm030 2021-07-09T15:38:47Z https://community.qlik.com/t5/App-Development/Create-Master-Calendar-With-5-4-4-Calendar/m-p/1821176#M67316 <P>Hi, googling it I found this:&nbsp;<A href="https://community.qlik.com/t5/Documents/Calendars/ta-p/1496392" target="_blank">https://community.qlik.com/t5/Documents/Calendars/ta-p/1496392</A></P><P>Ther is an attachment with diffrerent calendars, look for the&nbsp;5-4-4</P> Sat, 10 Jul 2021 07:15:28 GMT https://community.qlik.com/t5/App-Development/Create-Master-Calendar-With-5-4-4-Calendar/m-p/1821176#M67316 rubenmarin 2021-07-10T07:15:28Z