topic Re: Intervalmatch with intervals in QlikView

Intervalmatch with intervals

Anonymous — Mon, 10 Nov 2014 16:11:23 GMT

Hello everybody.

I would like to know how i could map this tables:

Production Hist by Machine
Machine ID
Datehour
Partial amount

Worker - Role
Id Worker
Id Role
Worker login datehour
Worker logout datehour

Role - Machines
Id Role
From Datehour
To Datehour
Machine ID

I would like to know production by worker = sum(Partial amount) The roles can change operative machines dynamically and worker can change his/her role dynamically.

Please, i need help.

Re: Intervalmatch with intervals

Mon, 10 Nov 2014 16:14:22 GMT

aggr(sum(partialamount),[worker-role]))

Re: Intervalmatch with intervals

Anonymous — Mon, 10 Nov 2014 16:18:21 GMT

Incorrect.but thanks

I need Partialamount with machine dates between worker login and logout and the same time between role-machine from and to dates

Re: Intervalmatch with intervals

whiteline — Mon, 10 Nov 2014 20:45:33 GMT

Hi.

You can link Production history and Roles using Machine ID, From Datehour, To Datehour, Datehour. It's an advanced intervalmatch case with a key field (refer to the help).

Using that linktable you can get the relation between Id Role and Datehour. Then you can similarly link Workers using Id Role, Datehour, Worker login datehour, Worker logout datehour.

Now you can draw the scheme and avoid the loop references with some complex keys.

I guess that different workers don't chose the same roles at the same time.

Re: Intervalmatch with intervals

Anonymous — Tue, 11 Nov 2014 07:36:39 GMT

Thanks for your answer,

Workers could chose the same role at the same time.

Re: Intervalmatch with intervals

whiteline — Tue, 11 Nov 2014 21:09:38 GMT

So that they can use the same machine at the same time. Then you should decide how the amount of work should be calculated.

Anyway the logic provided above is still applicable.