Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
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.