Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Not applicable
‎2017-09-07 11:39 AM

Occupancy with two dates

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

238 Views
0 Likes
0 Replies