Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

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