Working Days per Month

Mon, 01 Oct 2012 20:28:38 GMT

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

Year	Month	=(NetWorkingDays)

2012	Jan
2012	Feb
2012	Mar
2012	Apr
2012	May
2012	Jun
2012	Jul
2012	Aug
2012	Sep

Any help would be aapreciated

Thanks

Tim

Re: Working Days per Month

swuehl — Mon, 01 Oct 2012 21:02:52 GMT

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

topic Working Days per Month in QlikView

Working Days per Month

Re: Working Days per Month