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

Date interval excluding holidays but not weekends

Hello,

I have a table with a column that represents StartDate and another column that represents EndDate.

My goal is to know the number of days between these two dates exluding holidays but not weekends.

I have a separate table with a column saying all the holidays and weekends (excluding some saturdays) and also a variable with these values listed in the format : 'Date1', 'Date2', 'Date3' etc.

I would highly appreciate if someone could help me out!

2 Replies
Ricardo_Gerhard
Employee
Employee

Dear Eduardo,

   Do want to to this information on load script or dashboard?

Take a look on this article:

networkdays - script and chart function ‒ Qlik Sense

Ricardo Gerhard
OEM Solution Architect
LATAM
Anonymous
Not applicable
Author

Thank you for your response. Networkdays function takes out all the weekends, which is not my main goal..