Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
jumiprado
Creator
Creator

Intervals entry - output

Hey guys! How r u? I have a data like DATA excel attached, and i m looking for a solution like this table

ef_nameinoutDif hh:mmTotal hh:mmOut time hh:mmTotal Out Time 
Agent 129/01/2015 12:0929/01/2015 16:1304:04:0006:51:00-00:19:00
Agent 129/01/2015 16:1629/01/2015 16:2100:05:0006:51:0000:03:0000:19:00
Agent 129/01/2015 16:2429/01/2015 16:5600:32:0006:51:0000:03:0000:19:00
Agent 129/01/2015 17:0029/01/2015 17:1500:15:0006:51:0000:04:0000:19:00
Agent 129/01/2015 17:1829/01/2015 17:5000:32:0006:51:0000:03:0000:19:00
Agent 129/01/2015 17:5329/01/2015 18:0600:13:0006:51:0000:03:0000:19:00
Agent 129/01/2015 18:0929/01/2015 19:1901:10:0006:51:0000:03:0000:19:00
Agent 206/03/2019 07:0806/03/2019 08:3101:23:0004:39:00Error01:37:00
Agent 206/03/2019 08:3706/03/2019 08:5000:13:0004:39:0000:06:0001:37:00
Agent 206/03/2019 08:5006/03/2019 08:5100:01:0004:39:0000:00:0001:37:00
Agent 206/03/2019 08:52 Error04:39:0000:01:0001:37:00
Agent 206/03/2019 09:02 Error04:39:00Error01:37:00
Agent 206/03/2019 09:17 Error04:39:00Error01:37:00
Agent 206/03/2019 09:3206/03/2019 09:3600:04:0004:39:00Error01:37:00
Agent 206/03/2019 09:36 Error04:39:0000:00:0001:37:00
Agent 206/03/2019 09:5806/03/2019 09:5900:01:0004:39:00Error01:37:00
Agent 206/03/2019 10:01 Error04:39:00Error01:37:00
Agent 206/03/2019 10:05 Error04:39:00Error01:37:00
Agent 206/03/2019 10:17 Error04:39:00Error01:37:00
Agent 206/03/2019 10:25 Error04:39:00Error01:37:00
Agent 206/03/2019 10:4606/03/2019 10:4900:03:0004:39:00Error01:37:00
Agent 206/03/2019 11:0206/03/2019 11:1100:09:0004:39:0000:13:0001:37:00
Agent 206/03/2019 11:1606/03/2019 11:1600:00:0004:39:0000:05:0001:37:00
Agent 206/03/2019 11:1906/03/2019 11:1900:00:0004:39:0000:03:0001:37:00
Agent 206/03/2019 11:21 Error04:39:0000:02:0001:37:00
Agent 206/03/2019 11:2406/03/2019 11:5300:29:0004:39:00Error01:37:00
Agent 206/03/2019 11:58 Error04:39:0000:05:0001:37:00
Agent 206/03/2019 12:00 Error04:39:00Error01:37:00
Agent 206/03/2019 12:01 Error04:39:00Error01:37:00
Agent 206/03/2019 12:05 Error04:39:00Error01:37:00
Agent 206/03/2019 12:0706/03/2019 12:4700:40:0004:39:00Error01:37:00
Agent 206/03/2019 12:52 Error04:39:0000:05:0001:37:00
Agent 206/03/2019 13:07 Error04:39:00Error01:37:00
Agent 206/03/2019 13:1106/03/2019 13:3800:27:0004:39:00Error01:37:00
Agent 206/03/2019 13:5106/03/2019 13:5100:00:0004:39:0000:13:0001:37:00
Agent 206/03/2019 14:0106/03/2019 14:0200:01:0004:39:0000:10:0001:37:00
Agent 206/03/2019 14:02 Error04:39:0000:00:0001:37:00
Agent 206/03/2019 14:1006/03/2019 14:1100:01:0004:39:00Error01:37:00
Agent 206/03/2019 14:11 Error04:39:0000:00:0001:37:00
Agent 206/03/2019 14:14 Error04:39:00Error01:37:00
Agent 206/03/2019 14:16 Error04:39:00Error01:37:00
Agent 206/03/2019 14:17 Error04:39:00Error01:37:00
Agent 206/03/2019 14:18 Error04:39:00Error01:37:00
Agent 206/03/2019 14:20 Error04:39:00Error01:37:00
Agent 206/03/2019 14:23 Error04:39:00Error01:37:00
Agent 206/03/2019 14:26 Error04:39:00Error01:37:00
Agent 206/03/2019 14:27 Error04:39:00Error01:37:00
Agent 206/03/2019 14:28 Error04:39:00Error01:37:00
Agent 206/03/2019 14:29 Error04:39:00Error01:37:00
Agent 206/03/2019 14:32 Error04:39:00Error01:37:00
Agent 206/03/2019 14:33 Error04:39:00Error01:37:00
Agent 206/03/2019 14:34 Error04:39:00Error01:37:00
Agent 206/03/2019 14:35 Error04:39:00Error01:37:00
Agent 206/03/2019 14:3606/03/2019 14:3700:01:0004:39:00Error01:37:00
Agent 206/03/2019 14:3806/03/2019 14:3800:00:0004:39:0000:01:0001:37:00
Agent 206/03/2019 14:3906/03/2019 14:4000:01:0004:39:0000:01:0001:37:00
Agent 206/03/2019 14:40 Error04:39:0000:00:0001:37:00
Agent 206/03/2019 14:42 Error04:39:00Error01:37:00
Agent 206/03/2019 14:43 Error04:39:00Error01:37:00
Agent 206/03/2019 14:44 Error04:39:00Error01:37:00
Agent 206/03/2019 14:45 Error04:39:00Error01:37:00
Agent 206/03/2019 14:46 Error04:39:00Error01:37:00
Agent 206/03/2019 14:5406/03/2019 15:0000:06:0004:39:00Error01:37:00
Agent 206/03/2019 15:01 Error04:39:0000:01:0001:37:00
Agent 206/03/2019 15:0206/03/2019 15:0400:02:0004:39:00Error01:37:00
Agent 206/03/2019 15:06 Error04:39:0000:02:0001:37:00
Agent 206/03/2019 15:10 Error04:39:00Error01:37:00
Agent 206/03/2019 15:11 Error04:39:00Error01:37:00
Agent 206/03/2019 15:12 Error04:39:00Error01:37:00
Agent 206/03/2019 15:13 Error04:39:00Error01:37:00
Agent 206/03/2019 15:1406/03/2019 15:3100:17:0004:39:00Error01:37:00
Agent 206/03/2019 15:34 Error04:39:0000:03:0001:37:00
Agent 206/03/2019 15:37 Error04:39:00Error01:37:00
Agent 206/03/2019 15:3806/03/2019 15:3900:01:0004:39:00Error01:37:00
Agent 206/03/2019 15:4106/03/2019 15:4100:00:0004:39:0000:02:0001:37:00
Agent 206/03/2019 15:46 Error04:39:0000:05:0001:37:00
Agent 206/03/2019 15:4806/03/2019 16:2700:39:0004:39:00Error01:37:00

 

Is It possible?

 

Thanks!

Labels (4)
4 Replies
tincholiver
Creator III
Creator III

Yes, it is possible but can you tell us how the last two columns are calculated?
jumiprado
Creator
Creator
Author

of course, thanks for answer!

the field Out Time is the difference between the previous out and the next "in" for each Agent and for each day. in the example the first row dont have it because the day starts at the first row, but the second row yes.

For the Total Out time is the sum for each agent each day, so i need to calculate how much time is each agent out and sum that per day!

ef_nameinoutDif hh:mmTotal hh:mmOut time hh:mmTotal Out Time 
Agent 129/01/2015 12:0929/01/2015 16:1304:04:0006:51:00-00:19:00
Agent 129/01/2015 16:1629/01/2015 16:2100:05:0006:51:0000:03:0000:19:00

 

i hope i was clear!

 

Thanks again!

anushree1
Specialist II
Specialist II

Please check the attached

tincholiver
Creator III
Creator III

Thank you very much Anushree,
I hope it is the solution that Jumiprado is looking for.