Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2023, a live, in-person thrill ride. April 17 - 20, 2023, in Las Vegas! REGISTER TODAY
cancel
Showing results for 
Search instead 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
jonathandienst
Partner - Champion III
Partner - Champion III

Something like this:

Data:

LOAD

  User,

  Date,

  Quantity,

  TimeStamp

FROM ....;

Join (Data)

LOAD User,

  Date,

  Min(TimeStamp) As StartTime,

  Max(TimeStamp) As FinishTime,

Resident Data

Group By User, Date;

Final:

LOAD

  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 ?