topic Re: Calculate the Workday include the Saturday or Sunday in QlikView

Calculate the Workday include the Saturday or Sunday

Wed, 25 Nov 2020 16:16:04 GMT

I need to calculate the workday.

Example:

Calculate the Workday from 2016/02/01 ~ 2016/02/07

Now I have Workday database for weekend like below

My Expression : LastWorkDate(StartDay,4) But it does not include the day (2016/02/06)

How I could to write the expression? Many thanks.

Chanty4u — Wed, 16 Mar 2016 09:56:51 GMT

= LastWorkDate('DayName',4)

senpradip007 — Wed, 16 Mar 2016 09:57:17 GMT

Do want to calculate in the front end or in the script?

Wed, 16 Mar 2016 15:36:53 GMT

in the script

Wed, 16 Mar 2016 15:37:42 GMT

But the Workday on Saturday or Sunday could not be calculate.

jagan — Wed, 16 Mar 2016 15:48:28 GMT

Hi,

Check this link below and adjust the script accordingly

Regards,

jagan.

senpradip007 — Thu, 17 Mar 2016 05:55:08 GMT

Hi Jiadong,

Use this macro to calculate no of Saturday in the date range and then calculate the net working days. Hope it will help.