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

Set expression to get elapsed time

Can anyone help me with how to do a set expression to calculate elapsed time, given this table? It can't be done in the load script, because i need to compute it ad hoc, based on user selections:

Log ID Start Date Time End Date Time Affected ID
1 10/03/2022 8:00 10/03/2022 10:00 A
1 10/03/2022 8:00 10/03/2022 10:00 B
1 10/03/2022 8:00 10/03/2022 10:00 C
2 10/03/2022 9:00 10/03/2022 10:30 A
3 10/03/2022 14:00 10/03/2022 15:00 A

 

I am having trouble when Start and End times overlap.

My intended output for the Total Elapsed Time of Affected ID A = 210 mins.

 

Thank you.

Labels (2)
1 Reply
adrianfer
Contributor III
Contributor III
Author

If can't be done thru set expression, could it possibly be done in the load script?