Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Coming Aug. 9: New Simplified Authoring for Qlik Sense SaaS – For Details, CLICK HERE
Showing results for 
Search instead for 
Did you mean: 
Contributor III
Contributor III

Evaluate the number of races per hours per hour, per day, per week and per month


I try to analyze the service performed by stretcher bearers in a hospital.

A stretcher's race is characterized by a reference, a date and time of departure and a date and time of arrival.

I loaded a table with these 3 fields: Ref (unique reference), DateDep (date and time of departure DD / MM / YYYY HH: MM) and DateArr (date and time of arrival DD / MM / YYYY HH: MM )

I would like to evaluate the number of races per hours per hour, per day, per week and per month.

How can I do ?

Thank you for your help


1 Reply

Not quite sure what you mean with 'evaluate the number of races per hours per hour'. Could you elaborate?

Maybe by posting some input data and your expected result?

Maybe you are looking for something similar like

Re: How to count how many people was/are in the building??

I would start with creating records for the most granular time period (hour) for each Reference ID using a WHILE loop.

Maybe something like

Utilization per hour