topic Re: Working Day in the Month in QlikView

Working Day in the Month

stuwannop — Wed, 27 Feb 2013 10:25:22 GMT

Hi All

I'm building a report for cash collection and I'm struggling to figure out how to report the following (ideally I can just drop this into my master calendar script):

What I want is the WORKING Day Number in the month. I suspect the NetworkDays function comes in here but I'm not sure how to report the Working Day Number - for example (in uk date format):

01/03/2013 (Friday 1st) = 1

02/03/2013 (Saturday 2nd) = NULL

03/03/2013 (Sunday 3rd) = NULL

04/03/2013 (Monday 4th) = 2

05/03/2013) (Tuesday 5th) = 3

etc. etc.

Thanks for any help.

Stu

Re: Working Day in the Month

nagaiank — Wed, 27 Feb 2013 10:44:37 GMT

Attached is a solution using NetWorkDays() function.

Re: Working Day in the Month

kaushiknsolanki — Wed, 27 Feb 2013 10:55:01 GMT

Hi,

Have a look at the attached application for solution.

The logic used is, you flag everyday as 1 except Sat and Sunday. Then you sum up the flag values to get the total number of days.

Hope its clear.

Regards,

Kaushik Solanki