topic Re: Count of Working days in QlikView

Count of Working days

ariel_klien — Tue, 13 Aug 2013 08:30:39 GMT

Hello all experts,

my problem is that I want in his function to extract the Number of Working day for the selected month.

my filed are:

this is my function:

=NetWorkDays(date#('01/'&source.ACTIVITY_MM&'/'&source.ACTIVITY_YYYY,'DD/MM/YYYY'),

if(text(GetFieldSelections(source.ACTIVITY_MM))=text(Date(ReloadTime(),'MM')),date(ReloadTime(),'DD/MM/YYYY')),

date#(

day(monthend(date#'01/'&max(GetFieldSelections(source.ACTIVITY_MM))&'/'&source.ACTIVITY_YYYY,'DD/MM/YYYY')))

&'/'&source.ACTIVITY_MM&'/'&source.ACTIVITY_YYYY))

For example if I chose MM=02, YYYY=2013 then the function will return 28,

if I chose MM=07, YYYY=2013 then the function will return 31,

if I chose MM=08, YYYY=2013 then the function will return 9 -( until the reload time)

Sadly it isn't working.

Any Idea?

Ariel

swuehl — Tue, 13 Aug 2013 08:44:19 GMT

You can use makedate() function instead of date#() date interpretation, which should make things much simpler:

=NetWorkDays(makedate(source.ACTIVITY_YYYY,source.ACTIVITY_MM),

if(text(GetFieldSelections(source.ACTIVITY_MM))=text(Date(ReloadTime(),'MM')),

ReloadTime(),

monthend(makedate(source.ACTIVITY_YYYY,source.ACTIVITY_MM)))

)

ariel_klien — Tue, 13 Aug 2013 08:49:24 GMT

Working fine.

Thanks.