Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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.
Tags (2)
Labels (2)
1 Solution

Accepted Solutions
Highlighted
MVP & Luminary
MVP & Luminary

Re: Calculate business working hours

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

Re: Calculate business working hours

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

Re: Calculate business working hours

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

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