dates used seperately

[dries_clairhout]

Hello,

A weird question for you guys.

I have a table with scanning times from a warehouse this also contains a user and a Datefield.

We have already setup a picking qliksense where a Date is used from another table.

Now we calculate the number of orders/workday (7.33)

Now this calculation should be Number of orders/number of hours picked.

So I have 2 common fields:

The user (where I have to put the link I think) but also a date (wich has to be used also)

Any suggestions? I have the 2 tables here:

[fosuzuki · Accepted solution]

If I understood it right, I think you could concatenate both tables, using the same date field for both dates.

Then, you would be able to calculate something like this: Count(OrderNo) / Sum(Duration).

Hope this helps