Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
ariel_klien
Specialist
Specialist

Count of working Days

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:

source.ACTIVITY_MMsource.ACTIVITY_YYYY
012013
022013
032013
042013
052013
062013
072013
082013

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?

BR

Ariel

2 Replies
swuehl
MVP
MVP

Please, no cross postings. It makes it hard to follow a discussion.

Most forum users watch most of the discussion groups anyway, I think.

See your other thread a for suggested solution.

ariel_klien
Specialist
Specialist
Author