topic Re: Previous week Networking Day in QlikView

Previous week Networking Day

Anonymous — Tue, 20 Mar 2018 10:03:35 GMT

I am trying to create a variable which shows the number of working days in a previous week

This shows a working days in a current week.

Let Netwrkngdaysinaweek=NetWorkDays(Floor(WeekStart(Today())),Today());

shall i get something similar to this for the previous week?

YoussefBelloum — Tue, 20 Mar 2018 10:06:23 GMT

Hi,

try this:

Let Netwrkngdaysinaweek=NetWorkDays(Floor(WeekStart(Today(),-1)),Today());

YoussefBelloum — Tue, 20 Mar 2018 10:09:13 GMT

or this for only the last week:

=NetWorkDays(WeekStart(Today(),-1),WeekEnd(Today(),-1))