topic Re: Difference between days excluding weekends and holidays? in QlikView

Difference between days excluding weekends and holidays?

qlikuser222 — Tue, 22 Mar 2016 14:25:15 GMT

Hi,

I want to get the difference between start date and end date for a process excluding weekends and holidays.

Can anyone please help me ?

Re: Difference between days excluding weekends and holidays?

Chanty4u — Tue, 22 Mar 2016 14:45:29 GMT

chk dis

Exclude Weekends (Friday and Saturday) and non working hours from Dates Difference

Re: Finding working days excluding weekend and holidays

Re: Difference between days excluding weekends and holidays?

Anonymous — Tue, 22 Mar 2016 14:50:17 GMT

Have al ook at the NetworkDays() function.

Here is the Help entry for it from the QV Desktop Help :

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.

Examples:

networkdays ('2007-02-19', '2007-03-01') returns 9

networkdays ('2006-12-18', '2006-12-31', '2006-12-25', '2006-12-26') returns 8

Re: Difference between days excluding weekends and holidays?

Colin-Albert — Tue, 22 Mar 2016 14:54:34 GMT

The networkdays() function will do this. You need to provide the start date, end date and a comma separated list of holiday dates.

You can use the concat() function to generate the comma separated list of holidays in a separate table and then p[eek the result into a variable.