topic Master Calendar in QlikView https://community.qlik.com/t5/QlikView/Master-Calendar/m-p/998346#M339506 <HTML><HEAD></HEAD><BODY><P>I have loaded the Master Calendar. The data file loaded only indicates week ending dates which are each Friday.</P><P></P><P>In the attached example, I have a multi-box to select desired date/dates. My question is how to get the selection box to only indicate the Friday week ending dates rather than all dates.</P><P></P><P>Thanks in advance for any help....</P></BODY></HTML> Mon, 05 Oct 2015 15:16:08 GMT tigerfan81 2015-10-05T15:16:08Z Master Calendar https://community.qlik.com/t5/QlikView/Master-Calendar/m-p/998346#M339506 <HTML><HEAD></HEAD><BODY><P>I have loaded the Master Calendar. The data file loaded only indicates week ending dates which are each Friday.</P><P></P><P>In the attached example, I have a multi-box to select desired date/dates. My question is how to get the selection box to only indicate the Friday week ending dates rather than all dates.</P><P></P><P>Thanks in advance for any help....</P></BODY></HTML> Mon, 05 Oct 2015 15:16:08 GMT https://community.qlik.com/t5/QlikView/Master-Calendar/m-p/998346#M339506 tigerfan81 2015-10-05T15:16:08Z Re: Master Calendar https://community.qlik.com/t5/QlikView/Master-Calendar/m-p/998347#M339507 <HTML><HEAD></HEAD><BODY><P>Two possible solutions. The second is the better one:</P><P></P><UL><LI>If you want to stay with the Cookbook library routine, add a field to your Master Calendar that calculates the week ending date from the date in each row. Show this field on the sheet.</LI><LI>If not, create your own Master Calendar by determining first and last Fridays from your SQL SELECT result and creating a list by AUTOGENERATING rows and adding (RowNo()-1)*7 days to the starting Friday until you reach the last Friday.</LI></UL><P></P><P>There are lots of Master Calendar examples available for download and testing in the community.</P><P></P><P>Peter</P></BODY></HTML> Mon, 05 Oct 2015 15:39:53 GMT https://community.qlik.com/t5/QlikView/Master-Calendar/m-p/998347#M339507 Peter_Cammaert 2015-10-05T15:39:53Z Re: Master Calendar https://community.qlik.com/t5/QlikView/Master-Calendar/m-p/998348#M339508 <HTML><HEAD></HEAD><BODY><P>Thanks for your help....</P></BODY></HTML> Mon, 05 Oct 2015 16:16:30 GMT https://community.qlik.com/t5/QlikView/Master-Calendar/m-p/998348#M339508 tigerfan81 2015-10-05T16:16:30Z