0 Replies Latest reply: Sep 7, 2017 11:39 AM by Ian Galbraith RSS

    Occupancy with two dates

    Ian Galbraith

      Hi all,

      I'm try to calculate the occupancy of a car park each hour of the day.  I can calculate the information easily enough in Excel as it is just Entries before time X less Exits before time X.  I get the results as below.

       

      Capture.JPG

      The data I'm using has the following headers, VRM, DurationSeconds, EntryTime, ExitTime.

       

      To calculate the occupancy in Qlik I was trying to use Hour(EntryTime) as my dimension and count(EntryTime) - count (ExitTime) as my measure but the results always show as 0 for obvious reasons.

       

      Does anyone know of a solution?

       

      Thanks

      Ian