Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
May 18th 10AM ET, Live Chat, bring your QlikView questions. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
bryanalmeida525
Contributor II
Contributor II

Need to Measure amount of Hours from two schedule tables

Hello Everyone, 

I am trying to meausre amount of working time based on a certain schedule to determine how many overtime hours were worked for each employee ID. 

Capture.PNG

 What i have is a certain ID set with a start and end time. I also have a schedule set with amount of overtime hours based on the ID's location of EC or WC. I would like to have a sum of the amount of hours that was worked in overtime between the two dates based on the employee's ID location. 

 

I am not sure If a master calendar would help me, or a certain loop. Please note that this is a small sample size and will be running this for thousands of rows. 

I appreciate any feedback and assitance. 

 

3 Replies
alex00321
Creator II
Creator II

Hi, what is the standard working hours per day? And seems your working hours are also not accurate, take employee A as example, he/she started on 1/1 and ended on 1/2, seems that is over 24 hours, right?
Thanks!
bryanalmeida525
Contributor II
Contributor II
Author

Hello, 

The assumption in this schedule scenario would be that any amount of time that is not overtime is regular working hour. I would just like to see if there was a way to sum the total overtime hours for each employee that falls between the designated start and end date. 

 

The employee ID is not per individual It is a group of individuals throught the day, this is a sample data to help me get a better understanding on how I can proceed. 

 

 

Brett_Bleess
Support (Former)
Support (Former)

Best I can offer is the Design Blog area, below is the base link, use that to do a search of things in just that area, there are hundreds of how-to posts though, so finding ones that align with what you want to do may be a bit tricky, but I expect you should be able to find some decent things to prompt some ideas on how to approach things.

https://community.qlik.com/t5/Qlik-Design-Blog/bg-p/qlik-design-blog

Regards,
Brett

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.