# QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Action-Packed Learning Awaits! QlikWorld 2023. April 17 - 20 in Las Vegas: REGISTER NOW
cancel
Showing results for
Did you mean:
Not applicable

## Measurement of efficiency per Day

Hello everyone,

I am having issues to calculate a metric concerning operators efficiency.
I have a table with those fields :

- User

-Date

-Quantity

-TimeStamp (MM/DD/YY- HHMMSS)

I want to calculate the number of products scanned by operators / hour

I was assuming that the best way to do it was to calculate the difference between the first time stamp of the day made by an operator and the last one. Then to divide the quantity of products associated to this operator on this day by the difference just calculated.
Do you have any ideas about how could I do that?
I have joined my table if you want to have a look at it.
Thank you very much have a nice day

Alexandre BERNARD

2 Replies
Partner - Champion III

Something like this:

Data:

User,

Date,

Quantity,

TimeStamp

FROM ....;

Join (Data)

Date,

Min(TimeStamp) As StartTime,

Max(TimeStamp) As FinishTime,

Resident Data

Group By User, Date;

Final:

User,

Date,

Quantity,

StartTime,

FinishTime,

Quantity / ((FinishTime - StartTime) * 24) As ScansPerHour

Resident Data;

DROP Table Data;

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Not applicable
Author

Hi John,

Thx you very much for answering.

I have tried your formula but it does not seem to work unfortunately.

Would you know any set analysis formula that would enable me to re-create the order by statement so that i can select day and user in my table ?

Community Browser