Overlapping Times

robert99 — Tue, 27 May 2014 13:16:12 GMT

I trying to locate overlapping times (as shown below)

Engineers enter Job start and finish times. But often these times overlap by enginner

I have identified these as follows

if(Count(total <FSR_Start_Date, FSREngineer> FSR_Start_Date & FSREngineer)>1
,Count ( total <FSR_Start_Date , FSREngineer> FSR_Start_Date & FSREngineer))

and

(Count (total <FSR_Complete_Date , FSREngineer> FSR_Complete_Date & FSREngineer)>1
,Count ( total <FSR_Complete_Date ,
FSREngineer> FSR_Complete_Date & FSREngineer))

This works well if the start or finish time is the same. But not in the example shown below

I could use interval match (in some way). But is there another simple way to identify
overlapping times by engineers by using an expression (rather than a script
change)

(or includng in script without using interval match

Thanks for any assistance

Engineer	FSR Start	Complete
GB156	20/05/2014 10:00	20/05/2014 10:40
GB156	20/05/2014 12:30	20/05/2014 13:15
GB156	20/05/2014 13:30	20/05/2014 13:50
GB156	20/05/2014 13:31	20/05/2014 14:40
GB156	20/05/2014 13:51	20/05/2014 14:15
GB156	20/05/2014 14:55	20/05/2014 15:15
GB156	20/05/2014 15:15	20/05/2014 15:30

Re: Overlapping Times

Tue, 27 May 2014 14:06:18 GMT

Maybe something like this:

Re: Overlapping Times

robert99 — Tue, 27 May 2014 15:46:24 GMT

Thanks Dariusz

I will work on this tomorrow.

topic Re: Overlapping Times in QlikView

Overlapping Times

Re: Overlapping Times

Re: Overlapping Times