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.
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?