Display actvity by the the Hour

[#1]

Hi,

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.

Cheers

Simon

[Gysbert_Wassenaar]

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.