Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Not applicable
‎2016-03-16 04:58 AM

Calculate the Workday include the Saturday or Sunday

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.

   

WorkdayDay
2016/2/6Saturday
2016/2/14Sunday
2016/4/2Saturday
2016/4/30Saturday
2016/6/12Sunday
2016/9/18Sunday
2016/10/8Saturday
2016/10/9Sunday
2016/3/19Saturday
780 Views
0 Likes
6 Replies
Chanty4u
MVP
MVP
‎2016-03-16 05:56 AM

= LastWorkDate('DayName',4)

497 Views
0 Likes
senpradip007
Specialist III
Specialist III
‎2016-03-16 05:57 AM

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

497 Views
0 Likes
Not applicable
‎2016-03-16 11:36 AM
Author

In response to senpradip007

in the script

497 Views
0 Likes
Not applicable
‎2016-03-16 11:37 AM
Author

In response to Chanty4u

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

497 Views
0 Likes
jagan
Luminary Alumni
Luminary Alumni
‎2016-03-16 11:48 AM

Hi,

Check this link below and adjust the script accordingly

Master Calendar with Working days & Holidays Flag

Regards,

jagan.

497 Views
senpradip007
Specialist III
Specialist III
‎2016-03-17 01:55 AM

In response to

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.

NetWorkDays2.qvw
497 Views
0 Likes