topic Re: Room Empty or Occupied in QlikView https://community.qlik.com/t5/QlikView/Room-Empty-or-Occupied/m-p/432241#M161136 <HTML><HEAD></HEAD><BODY><P>You should look at Intervalmatch. With this prefix you can create a map between individual points in time and intervals.</P><P></P><P>You should also look at different types of Gantt charts to visualize this. <A _jive_internal="true" class="loading" href="https://community.qlik.com/docs/DOC-3113">http://community.qlik.com/docs/DOC-3113</A></P><P></P><P>HIC</P></BODY></HTML> Mon, 24 Sep 2012 12:39:09 GMT hic 2012-09-24T12:39:09Z Room Empty or Occupied https://community.qlik.com/t5/QlikView/Room-Empty-or-Occupied/m-p/432240#M161135 <HTML><HEAD></HEAD><BODY><P>HI </P><P>I have a table with roomno, start and end time so I can see when a room is occupied</P><P>I have also created a timeline for a whole day.&nbsp; (See attached example)</P><P></P><P>Now I want to make a table to seee when a room is occupied and when a room is empty </P><P></P><P>in this table it should be green then or is emoty, it should be red then, but it if the outcome of the expression is 1 whne the room is occupied and 0 when it is </P><P>emoty.</P><P></P><P>Does anyone have an idea how to solve this???</P></BODY></HTML> Sat, 22 Sep 2012 17:09:58 GMT https://community.qlik.com/t5/QlikView/Room-Empty-or-Occupied/m-p/432240#M161135 2012-09-22T17:09:58Z Re: Room Empty or Occupied https://community.qlik.com/t5/QlikView/Room-Empty-or-Occupied/m-p/432241#M161136 <HTML><HEAD></HEAD><BODY><P>You should look at Intervalmatch. With this prefix you can create a map between individual points in time and intervals.</P><P></P><P>You should also look at different types of Gantt charts to visualize this. <A _jive_internal="true" class="loading" href="https://community.qlik.com/docs/DOC-3113">http://community.qlik.com/docs/DOC-3113</A></P><P></P><P>HIC</P></BODY></HTML> Mon, 24 Sep 2012 12:39:09 GMT https://community.qlik.com/t5/QlikView/Room-Empty-or-Occupied/m-p/432241#M161136 hic 2012-09-24T12:39:09Z Re: Room Empty or Occupied https://community.qlik.com/t5/QlikView/Room-Empty-or-Occupied/m-p/432242#M161137 <HTML><HEAD></HEAD><BODY><P>Gants charts looking&nbsp; prommissing&nbsp; </P><P>Thanks</P></BODY></HTML> Mon, 24 Sep 2012 13:54:31 GMT https://community.qlik.com/t5/QlikView/Room-Empty-or-Occupied/m-p/432242#M161137 2012-09-24T13:54:31Z