topic Networkdays and Days Aged Question in QlikView

Networkdays and Days Aged Question

Fri, 12 Dec 2014 18:08:37 GMT

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

Re: Networkdays and Days Aged Question

saurabh5 — Fri, 12 Dec 2014 18:24:22 GMT

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