Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
Showing results for 
Search instead for 
Did you mean: 
Not applicable

networking days between two dates per month

Hi everyone,

I am trying to calculate the working days between two dates grouped by month.

Lets say for example I have a project that starts 11/05/2014 has duration of 240 working days, so it ends on LastWorkDate('11/05/2014',240) which is 10/04/2015.

I want to be able to calculate the number of working days per month in the calendar for this project. Obviously the starting month and the ending month of the project would have less working days as they will be calculated in a different way.

I was using NetWorkDays and LastWorkDate to make my expression work with no luck

Any good ideas??

Tags (1)
2 Replies
MVP & Luminary
MVP & Luminary

Re: networking days between two dates per month

If you're using month as a dimension in a chart then networkdays(min(MyDate), max(MyDate)) should show you the net working days per month

talk is cheap, supply exceeds demand
Not applicable

Re: networking days between two dates per month

Hi Gysbert,

How would a calculate workdays, if there is another column, that indicates the 'current' status, linked to the date?