Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
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

Tags (3)
1 Solution

Accepted Solutions
Highlighted
MVP
MVP

Re: Working Days per Month

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
Highlighted
MVP
MVP

Re: Working Days per Month

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