I've been trying to work out how to do this, but cant get my head around it. On paper it seems easily enough to do, but stuggling to stranslate into QlikView.
I have patients that have an arrival date & time and an end date and time, I want to be able to show a graph that plots the number of patients that are in the department by the hour.
Hope that makes sense.
This blog post might help: Creating Reference Dates for Intervals. The blog post deals with days as unit, but hours are just N/24 fractions of a day so the principle is the same. If you need more help, please post some sample data and the result you need.