topic Re: Occupancy in QlikView https://community.qlik.com/t5/QlikView/Occupancy/m-p/577973#M214916 <HTML><HEAD></HEAD><BODY><P>try like this hope will helps you</P><P></P><P>=count(interval(InDateTime-OutDateTime,'MM'))</P></BODY></HTML> Wed, 12 Feb 2014 22:42:05 GMT 2014-02-12T22:42:05Z Occupancy https://community.qlik.com/t5/QlikView/Occupancy/m-p/577970#M214913 <HTML><HEAD></HEAD><BODY><P>Hi All</P><P></P><P>I have a client that needs to show occupancy levels at different sites on a dashboard. This would be occupancy over time in different intervals. </P><P></P><P>For example, if site 101 has 100 spaces, the client gets an InDateTime and an OutDateTime for each visit of a customer and would like to see how many spaces are occupied in those intervals. </P><P></P><P>Does anyone know of the best way to do this?</P><P></P><P>I have tried calculating 10 minute intervals and using something simple like count(InDateTime) - Count(OutDateTime) but this does not work. </P><P></P><P>Many Thanks,</P><P></P><P>Simon</P></BODY></HTML> Wed, 12 Feb 2014 21:28:40 GMT https://community.qlik.com/t5/QlikView/Occupancy/m-p/577970#M214913 Simon_J 2014-02-12T21:28:40Z Re: Occupancy https://community.qlik.com/t5/QlikView/Occupancy/m-p/577971#M214914 <HTML><HEAD></HEAD><BODY><P>I think this might be helpful in your case:</P><P><A _jive_internal="true" href="https://community.qlik.com/blogs/qlikviewdesignblog/2013/02/12/reference-dates" title="http://community.qlik.com/blogs/qlikviewdesignblog/2013/02/12/reference-dates">http://community.qlik.com/blogs/qlikviewdesignblog/2013/02/12/reference-dates</A></P></BODY></HTML> Wed, 12 Feb 2014 22:10:35 GMT https://community.qlik.com/t5/QlikView/Occupancy/m-p/577971#M214914 swuehl 2014-02-12T22:10:35Z Re: Occupancy https://community.qlik.com/t5/QlikView/Occupancy/m-p/577972#M214915 <HTML><HEAD></HEAD><BODY><P>Thanks, I will take a look and let you know the outcome</P></BODY></HTML> Wed, 12 Feb 2014 22:24:24 GMT https://community.qlik.com/t5/QlikView/Occupancy/m-p/577972#M214915 Simon_J 2014-02-12T22:24:24Z Re: Occupancy https://community.qlik.com/t5/QlikView/Occupancy/m-p/577973#M214916 <HTML><HEAD></HEAD><BODY><P>try like this hope will helps you</P><P></P><P>=count(interval(InDateTime-OutDateTime,'MM'))</P></BODY></HTML> Wed, 12 Feb 2014 22:42:05 GMT https://community.qlik.com/t5/QlikView/Occupancy/m-p/577973#M214916 2014-02-12T22:42:05Z