Qlik Community

Ask a Question

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Qlik Highlights 2020 Giveaway! Watch, reply and have a chance to win a $200 Amazon Gift Card! Watch Video
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Date Diff (Working Days Only)

Hi,

I am looking for 2 formulas, one for the load script and one for an expression in a chart. Both formulas calculate the difference in two dates and have the same outcome.

I want to subtract two dates to find the date difference, however I only want to include working days.

for example (24/11/2009 - 20/11/2009) = 4 days, I want the answer to read 2 days as the 21/11/2009 and the 22/11/2009 are saturday and sunday and should therefore the excluded from the equation.

many thanks!

1 Solution

Accepted Solutions
Not applicable

Hi ,

networkdays ( start:date, end_date {, holiday} )

Returns the number of working days (Monday-Friday) between and including start_date and end_date taking into account any optionally listed holidays. All parameters should be valid dates or timestamps.

Hope this will help You.

View solution in original post

3 Replies
Not applicable

Hi ,

networkdays ( start:date, end_date {, holiday} )

Returns the number of working days (Monday-Friday) between and including start_date and end_date taking into account any optionally listed holidays. All parameters should be valid dates or timestamps.

Hope this will help You.

View solution in original post

Not applicable

Hi,

a hint is "NETWORKDAYS()". See QV help file.

Rainer

Not applicable

thanks guys!