Discussion board where members can get started with Qlik Sense.
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!
Do want to to this information on load script or dashboard?
Take a look on this article:
networkdays - script and chart function ‒ Qlik Sense
Thank you for your response. Networkdays function takes out all the weekends, which is not my main goal..