Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Display actvity by the the Hour


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.



1 Reply

Re: Display actvity by the the Hour

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.

talk is cheap, supply exceeds demand
Community Browser