Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
pgarcia75
New Contributor III

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

Hello

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


Patrice

Tags (1)
1 Reply
MVP
MVP

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

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