topic How to Design Calendar based on schedule dates & Leave of Absence? in QlikView https://community.qlik.com/t5/QlikView/How-to-Design-Calendar-based-on-schedule-dates-Leave-of-Absence/m-p/888889#M309782 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have the following 2 calendar dates ranges.&nbsp; One is the planned schedule date ranges for individual and the other is the leave date range taken by individual.&nbsp; I need to know how to design this so I can have a count of number of available people in a schedule date.</P><P></P><P>I had combine these 2 dates range under one table. the dates ranges is under the columns - Duration Start, Duration End.&nbsp; Highlight in yellow is the leave of absence.&nbsp; </P><P></P><P>How should I design this so I can meet my objective?</P><P></P><P>Example.</P><P></P><P> <IMG alt="SS.JPG" class="jive-image image-1" height="171" src="https://community.qlik.com/legacyfs/online/84381_SS.JPG" style="height: 171px; width: 768.260869565217px;" width="768" /></P><P></P><P>Thanks</P><P>Chun Wey</P></BODY></HTML> Thu, 23 Apr 2015 01:38:26 GMT 2015-04-23T01:38:26Z How to Design Calendar based on schedule dates & Leave of Absence? https://community.qlik.com/t5/QlikView/How-to-Design-Calendar-based-on-schedule-dates-Leave-of-Absence/m-p/888889#M309782 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have the following 2 calendar dates ranges.&nbsp; One is the planned schedule date ranges for individual and the other is the leave date range taken by individual.&nbsp; I need to know how to design this so I can have a count of number of available people in a schedule date.</P><P></P><P>I had combine these 2 dates range under one table. the dates ranges is under the columns - Duration Start, Duration End.&nbsp; Highlight in yellow is the leave of absence.&nbsp; </P><P></P><P>How should I design this so I can meet my objective?</P><P></P><P>Example.</P><P></P><P> <IMG alt="SS.JPG" class="jive-image image-1" height="171" src="https://community.qlik.com/legacyfs/online/84381_SS.JPG" style="height: 171px; width: 768.260869565217px;" width="768" /></P><P></P><P>Thanks</P><P>Chun Wey</P></BODY></HTML> Thu, 23 Apr 2015 01:38:26 GMT https://community.qlik.com/t5/QlikView/How-to-Design-Calendar-based-on-schedule-dates-Leave-of-Absence/m-p/888889#M309782 2015-04-23T01:38:26Z