Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Working Days per Month

I am trying to build out a table that has either a calculated dimension or expression that will give me the number of working days (Business Days) in the proper month

For Example I am trying to complete the following table in QV

YearMonth=(NetWorkingDays)
2012Jan
2012Feb
2012Mar
2012Apr
2012May
2012Jun
2012Jul
2012Aug
2012Sep

Any help would be aapreciated

Thanks

Tim

1 Solution

Accepted Solutions
swuehl
MVP
MVP

If you have a Date field connected to your Month and Year, you could use

=networkdays( min(Date), max(Date) )

edit:

I assume here that you got a value for each Date in the calendar. If not, try

=networkdays( monthstart(makedate(Year, Month)), monthend(makedate(Year, Month)) )

View solution in original post

1 Reply
swuehl
MVP
MVP

If you have a Date field connected to your Month and Year, you could use

=networkdays( min(Date), max(Date) )

edit:

I assume here that you got a value for each Date in the calendar. If not, try

=networkdays( monthstart(makedate(Year, Month)), monthend(makedate(Year, Month)) )