Skip to main content
Announcements
Qlik Connect 2025: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL: Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
joshrussin
Creator III
Creator III

Current work days in month

Trying to calculate the amount of work days in the current month.

I need to account for the weekends and holidays. I currently have a string variable with all of my selected holidays defined as 'vHolidays'.

Here is the expression I am trying to use to achieve said count. The current amount of days for this month would be 20, 4th of july.

=networkdays({$<Date={"$(=FirstWorkDate(Today()-1,1,$(vHolidays)))"}, Month = {"$(=Month(Today()))"}>} min(Date), max(Date))

10 Replies
sunny_talwar

I would not know anything about this because I don't have any knowledge about your data. If Max(Date) = 08/01/2017, you will have to check in the database as to why you are getting this value....