Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
robert99
Specialist III
Specialist III

Overlapping Times

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

EngineerFSR StartComplete
GB15620/05/2014 10:0020/05/2014 10:40
GB15620/05/2014 12:3020/05/2014 13:15
GB15620/05/2014 13:3020/05/2014 13:50
GB15620/05/2014 13:3120/05/2014 14:40
GB15620/05/2014 13:5120/05/2014 14:15
GB15620/05/2014 14:5520/05/2014 15:15
GB15620/05/2014 15:1520/05/2014 15:30
2 Replies
Not applicable

Maybe something like this:

robert99
Specialist III
Specialist III
Author

Thanks Dariusz

I will work on this tomorrow.