Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikView forum consolidation is complete. Labels are now required. LEARN ABOUT LABELS
cancel
Showing results for 
Search instead for 
Did you mean: 
pgarcia75
Contributor III
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

1 Reply
swuehl
MVP
MVP

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