topic Re: Occupancy count using master calendar in QlikView https://community.qlik.com/t5/QlikView/Occupancy-count-using-master-calendar/m-p/1093915#M929474 <HTML><HEAD></HEAD><BODY><P>See this blog post for one solution to this problem: <A href="https://community.qlik.com/qlik-blogpost/2940">Creating Reference Dates for Intervals</A></P></BODY></HTML> Thu, 17 Mar 2016 16:50:47 GMT Gysbert_Wassenaar 2016-03-17T16:50:47Z Occupancy count using master calendar https://community.qlik.com/t5/QlikView/Occupancy-count-using-master-calendar/m-p/1093914#M929473 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I am new to Qlik and please be nice to me.</P><P></P><P>Let's say we are running a hotel, and we record each guest's arrival and checkout dates.</P><P></P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Guest #</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Arrival Date</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Checkout Date</TH></TR><TR><TD style="padding: 2px;">1</TD><TD style="padding: 2px;">1/1/2016</TD><TD style="padding: 2px;">20/1/2016</TD></TR><TR><TD style="padding: 2px;">2</TD><TD style="padding: 2px;">3/1/2016</TD><TD style="padding: 2px;">14/1/2016</TD></TR><TR><TD style="padding: 2px;">3</TD><TD style="padding: 2px;">16/1/2016</TD><TD style="padding: 2px;">31/1/2016</TD></TR><TR><TD style="padding: 2px;">4</TD><TD style="padding: 2px;">19/1/2016</TD><TD style="padding: 2px;">NULL</TD></TR></TBODY></TABLE><P></P><P>And I want to plot a chart to report the occupancy (guest count) of the hotel on each given date.</P><P></P><P>How would QlikView do it?</P><P></P><P>Michael</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Occupancy-count-using-master-calendar/m-p/1093914#M929473 2020-11-25T16:16:04Z Re: Occupancy count using master calendar https://community.qlik.com/t5/QlikView/Occupancy-count-using-master-calendar/m-p/1093915#M929474 <HTML><HEAD></HEAD><BODY><P>See this blog post for one solution to this problem: <A href="https://community.qlik.com/qlik-blogpost/2940">Creating Reference Dates for Intervals</A></P></BODY></HTML> Thu, 17 Mar 2016 16:50:47 GMT https://community.qlik.com/t5/QlikView/Occupancy-count-using-master-calendar/m-p/1093915#M929474 Gysbert_Wassenaar 2016-03-17T16:50:47Z Re: Occupancy count using master calendar https://community.qlik.com/t5/QlikView/Occupancy-count-using-master-calendar/m-p/1093916#M929475 <HTML><HEAD></HEAD><BODY><P>It is a valid solution to my problem.</P><P></P><P>Thanks<IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P><P></P><P>Michael</P></BODY></HTML> Fri, 18 Mar 2016 02:02:42 GMT https://community.qlik.com/t5/QlikView/Occupancy-count-using-master-calendar/m-p/1093916#M929475 2016-03-18T02:02:42Z