Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
lotfiblo
Creator
Creator

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

Use Qalyptus for your Qlik Sense on-premise and Qlik Sense SaaS Reporting
Connect with me on Linkedin
1 Solution

Accepted Solutions
Anonymous
Not applicable

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

View solution in original post

2 Replies
Anonymous
Not applicable

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
Creator
Creator
Author

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

Use Qalyptus for your Qlik Sense on-premise and Qlik Sense SaaS Reporting
Connect with me on Linkedin