Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

eduardo_santos
New Contributor

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
Employee
Employee

Re: Date interval excluding holidays but not weekends

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
eduardo_santos
New Contributor

Re: Date interval excluding holidays but not weekends

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

Community Browser