topic Re: NetWorkDays: Excluding Friday and Saturday between two dates in QlikView

NetWorkDays: Excluding Friday and Saturday between two dates

Mon, 24 Aug 2015 11:17:52 GMT

Hi all,

I am trying to calculate count of days between any two given dates including boundary dates.

This count should exclude all Fridays and Saturdays ( as Fri and Sat are weekend in Middle East).

NetWorkDays() give count which excludes Sat and Sun by default.

Please suggest how can I customize or create expression to achieve the same excluding Fridays and Saturdays?

tresB — Mon, 24 Aug 2015 11:58:56 GMT

You could change the default week start and try thereafter with networkdays. Please refer: Ancient Gods and Modern Days for changing the week start.

senpradip007 — Mon, 24 Aug 2015 12:20:16 GMT

Have a look at the attachment.

sujeetsingh — Mon, 24 Aug 2015 12:28:42 GMT

Tresco a best way.

Mon, 24 Aug 2015 14:52:17 GMT

tresesco‌ and senpradip007‌ thanks for replying.

I Changed the order of day names and tried again.

SET DayNames='Sun;Mon;Tue;Wed;Thu;Fri;Sat';

I don't think the below is excluding Fridays and Saturdays.

For month of August I am getting below result.

NetWorkDays( MonthStart(date(Today())), MonthEnd(Date(Today()))) = 21

If it excludes Fri and Sat as expected, I should get 22 as result.

Please suggest.

Mon, 24 Aug 2015 15:17:31 GMT

Finally it worked this way without Setting DayNames variable.

=Networkdays(DateA+1, DateB+1)