Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

lotfiblo
New Contributor III

Calculate sum of working days of a dates list

Hello,

I would know if it is possible to calculate sum of  working days of a dates list  (without taking a count Saturday and Sunday )

I know that this fonction : networkdays(start:date, end_date {, holiday}) can calculate nember of days between two dates

But what I would like to have, is a sum of working days of a dates list, I have tried this fonction but it doesn't work : sum(networkdays([Due date] , [Posting date])   

So, It is possible to have the sum of the working days of this list ???


dates_list.gif

Thank you in advance

Lotfi

1 Solution

Accepted Solutions
jsn
Honored Contributor

Re: Calculate sum of working days of a dates list

The function says to use StartDate, EndDate as parameters. You seem to use EndDate, StartDate since I assume that Posting Date is the start date and Due Date is the end date

2 Replies
jsn
Honored Contributor

Re: Calculate sum of working days of a dates list

The function says to use StartDate, EndDate as parameters. You seem to use EndDate, StartDate since I assume that Posting Date is the start date and Due Date is the end date

lotfiblo
New Contributor III

Re: Calculate sum of working days of a dates list

Hi,

Thank you for reply,

you are right, by inversing [Due date] and [Posting date] the function works very well.

Thank you very much Johannes

Lotfi

Community Browser