Working days Monday to Saturday

[#1]

Hi guys,

I am trying to work out the total number of working days in each month. For my application apart from Sunday everyday is a working day.

For example

Month Day Working Day No

Jan 1  Mon           1

Jan 2  Tue            2

Jan 3  Wed           3

Jan 4  Thu             4

Jan 5  Fri               5

Jan 6  Sat              6

Jan 7  Sun              -

Jan 8  Mon             7

and so on for each month.

I have tried using networkdays but it only works with Monday to Friday and doesn't really give me what I need.

I am no QlikView expert, so I would appreciate some assistance.

Can someone help me out?

Thanks

[CELAMBARASAN]

Create a work day flag like

if(Day<>'Sun', 1) AS WorkDayFlag

To calculate work day number in script

Left Join(TableName)

Load

     DateField, //Assuming that you have date field in the table

     if(Previous(Month) = Month, Peek('WorkDayNo') + 1, 1) AS WorkDayNo

Resident TableName

Where WorkDayFlag=1;

[#3]

Please refer the following application

[#4]

Thanks for your reply.

Load

     DateField, //Assuming that you have date field in the table

     if(Previous(Month) = Month, Peek('WorkDayNo') + 1, 1) AS WorkDayNo

Resident TableName

Where WorkDayFlag=1;

What does the ‘WorkDayNo’ in the Peek function relate to?

I tried different date values there, but it didn’t work as expected.

Secondly, I want to return the number of business days in each month and not the entire time period in the application.

So if January has 27 business days, Feb1 should be 1 and Feb 2 should be 2 and so on.

Thank you

[MK_QSL]

Hi, Check my post on this...

http://community.qlik.com/docs/DOC-5314

[#6 · Accepted solution]

Hi  ,

First use this Set statement in your Script

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

Then please try the code as below

=Round((MonthEnd (Today()) - MonthStart(Today()) ) )    -

(Floor((MonthEnd (Today()) - MonthStart(Today()) )/7 ) +

if( num( WeekDay(MonthStart(Today())))+1<= Match('Sun', $(=chr(39) & Replace(DayNames, ';', chr(39) & ',' & chr(39)) & chr(39))) and

Match('Sun', $(=chr(39) & Replace(DayNames, ';', chr(39) & ',' & chr(39)) & chr(39))) <=num( WeekDay(MonthEnd(Today())))+1 ,1,0))

Here i used current month i.e today() , you can replace by the date field for every month.

Please let me know if there is anything

Regards

Yusuf

[#7]

Thanks