Qlik Community

Ask a Question

QlikView Integrations

Discussion Board for collaboration on QlikView Integration.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
abhishek_vn
Contributor
Contributor

Working Hours Calculation for different business work hours also excluding weekends and holidays and

Hallo guys,

I'm sorry for bringing this up again after all this years

First of all thank you for your solutions, it works great but I have to manage a slightly different situation.

Working hours are different on fridays. I mean, I have:

7:30 to 16:00 from monday to thursday

7:30 to 14:00 on friday

How do I accomplish the correct calculation giving this issue (Calculate the working hours betweeen 2 days given start and end date)? Is this possible?

1 Reply
edwin
Specialist III
Specialist III

you can determine the day of the week in your calendar using weekday function, you can then associate this to a table with weekday and time start and time end as fields or just total hours per day  

if you share your data model someone would be able to give specific help