Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Networkdays and Days Aged Question

I was wondering if someone could give me some examples of formulas I can use to solve my issue:

Example

Issue:  A Work Order is created on 12/1/2014 and closed 12/12/2014.  That is technically 12 days but two of them are weekends which no work gets done.  I want to base my days aged on NetWorkdays if that is possible.

Any ideas would be welcomed.

Thanks,

David

1 Solution

Accepted Solutions
saurabh5
Contributor II

Re: Networkdays and Days Aged Question

hi David,

you can use the networkdays function it will give you 10 days,

eg:

=

NetWorkDays(date(F1),date(F2))

where f1 is created date

          f2 is closed date

regards

Saurabh

1 Reply
saurabh5
Contributor II

Re: Networkdays and Days Aged Question

hi David,

you can use the networkdays function it will give you 10 days,

eg:

=

NetWorkDays(date(F1),date(F2))

where f1 is created date

          f2 is closed date

regards

Saurabh

Community Browser