Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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
6 Replies
Chanty4u
Champion III
Champion III

= LastWorkDate('DayName',4)

senpradip007
Specialist III
Specialist III

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

Not applicable
Author

in the script

Not applicable
Author

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

jagan
MVP
MVP

Hi,

Check this link below and adjust the script accordingly

Master Calendar with Working days & Holidays Flag

Regards,

jagan.

senpradip007
Specialist III
Specialist III

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.