topic Calcuating Business Hours in QlikView

Calcuating Business Hours

QVUser1 — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

From Below Screen Shot we can Find( billing Date ,Vessel Date,Billing time,Vessel Time,Month) . from these fields need to calculate the following

Working Hours : 09:00:00 AM to 05:00:00 PM
Working Hours :09:00:00 AM to 05:00:00 PM Excluding [Sat, Sun]

Output:

for Example 2 Row:

Billing Date Time 08-09-2017 09:00:04 AM and Vessel Date time 11-09-2017 11:00:03 AM

Working Hours required to fill the vessel is 10 hours because as we have remove dates of 09 sep and 10 Sep 2017 as they are weekends and non working hours.

Regards,

Bharath.B

Re: Calcuating Business Hours

jagan — Mon, 11 Sep 2017 08:28:40 GMT

Hi,

Check this links hope it helps you.

Business Working Hours Calculation

Business hours function

Re: Calcuating Business Hours

QVUser1 — Mon, 11 Sep 2017 09:36:20 GMT

Hi Jagan,

thanks for the reply.

But can u please explain the same with above example

Re: Calcuating Business Hours

jagan — Mon, 11 Sep 2017 09:46:30 GMT

Hi Bharat,

Go through those links it has very clear cut examples with good description.

Regards,

Jagan.

Re: Calcuating Business Hours

QVUser1 — Wed, 29 Nov 2017 12:16:28 GMT

HI Jagan,

This Code is Working perfectly only for Working hours from 9 and 18 hours.

can u plz suggest me values to define values for morning 9.00 AM and Evening 17.30 PM

Because if i define variable values with 09 and 17.30 its not Working.

Can u please Help me out

Re: Calcuating Business Hours

jagan — Fri, 01 Dec 2017 07:57:09 GMT

Hi,

Change this variables

https://community.qlik.com/servlet/JiveServlet/showImage/102-16489-2-122518/pastedImage_20.png

Regards,

Jagan.

Re: Calcuating Business Hours

QVUser1 — Tue, 05 Dec 2017 13:51:18 GMT

Hi Jagan,

I clearly Agree with your point. but here iam asking about morning 9.30 and evening 17.30

this coding is not working for Let vstarthour=9.30

let Vendhour=17.30

Re: Calcuating Business Hours

QVUser1 — Wed, 29 Aug 2018 07:31:46 GMT

Hi Jagan,

I clearly Agree with your point. but here iam asking about morning 9.30 and evening 17.30

this coding is not working for Let vstarthour=9.30

let Vendhour=17.30