topic Calculate business working hours in QlikView

Calculate business working hours

Claudiu_Anghelescu — Sat, 16 Nov 2024 18:58:55 GMT

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.

@Kushal_Chawda

@rwunderlich
@marcus_sommer

@IAMDV

Re: Calculate business working hours

marcus_sommer — Mon, 09 Mar 2020 07:59:43 GMT

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

Re: Calculate business working hours

Claudiu_Anghelescu — Tue, 23 Jun 2020 18:18:16 GMT

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