Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Talk to Experts Tuesday, Live Q&A, September 22: Moving from QlikView to Qlik Sense. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Specialist
Specialist

Calculate business working hours

Hi,

I want to calculate the working hours between StartDateTime and EndDateTime.

There are multiple posts on community but only for 1 location, e.g. 09:00 -> 18:00. 

Which approach I have to apply if I have different locations with different working hours? 
E.g:

Paris:        09:00 -> 18:00

London : 08:00 -> 16:00 

Roma:      07:00 -> 15:00

And excluding holidays that can be different for each location. 

@Kush  

@rwunderlich 
@marcus_sommer 

@IAMDV 

To help community find solutions, please don't forget to mark as correct.
Labels (2)
1 Solution

Accepted Solutions
Highlighted
MVP & Luminary
MVP & Luminary

The logic itself didn't change if you have a single location or multiple ones with different properties. You need just to repeat your basic-data for the holidays / working hours and merge them together - personally I would simply concatenate them and adding the location to the key-field.

- Marcus

View solution in original post

2 Replies
Highlighted
MVP & Luminary
MVP & Luminary

The logic itself didn't change if you have a single location or multiple ones with different properties. You need just to repeat your basic-data for the holidays / working hours and merge them together - personally I would simply concatenate them and adding the location to the key-field.

- Marcus

View solution in original post

Highlighted
Specialist
Specialist

How to proceed if I have vStartHour=5, vEndHour=2 ?

To help community find solutions, please don't forget to mark as correct.