Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

"networkday" with the holiday but consider the Sabbath as a working day?

hello can someone help me and answer the following question thanks

there is a statement like "networkday" with the holiday but consider the Sabbath as a working day?

4 Replies
Anonymous
Not applicable
Author

The developer can feed in a list of holidays for the networkdays function:

networkdays (start:date, end_date {, holiday})

Returns the number of working days (Monday-Friday) between and including start_date and end_date taking into account any optionally listed holidays. All parameters should be valid dates or timestamps.

Examples:

networkdays ('2007-02-19', '2007-03-01') returns 9 

networkdays ('2006-12-18', '2006-12-31', '2006-12-25', '2006-12-26') returns 8

Anonymous
Not applicable
Author

thanks for the reply but it is not what I need.

I want to consider working days from Monday to Saturday including

Anonymous
Not applicable
Author

Ah, in that case it sounds easier to create a mapping table with the different weekdays and a 1 or 0 flag as return value depending on if it should be considered a working day or not. Then you can use Applymap and create a field in your calendar with a 1 for a working day and use Sum(FlagField) in your front end to get the number of working days.

Anonymous
Not applicable
Author

in practice not there is a similar function to NetWorkDay but also consider the Sabbath as a working day