topic Re: NetworkDays script in QlikView

NetworkDays script

ivandrago — Wed, 26 Mar 2014 12:46:55 GMT

Hi,

I have the attached Document, I have a Holidays worksheet and a Orders Worksheet.
I want to use the Function NetworkDays againts the DateEntered, DateInvoiced fields and
using the Holidays to exclude the days between.
But I am having trouble trying to do this via the script?

Thanks

Re: NetworkDays script

ivandrago — Wed, 26 Mar 2014 17:03:53 GMT

Anyone?

Re: NetworkDays script

aveeeeeee7en — Wed, 26 Mar 2014 17:53:58 GMT

Hi Ivan

See the Attachment.

Hope it works for you.

Regards

Aviral Nag

Re: Re: NetworkDays script

aveeeeeee7en — Wed, 26 Mar 2014 18:05:33 GMT

If you want Number of Days excluding Holidays than see the Attachment.

Re: NetworkDays script

ivandrago — Wed, 26 Mar 2014 19:23:43 GMT

Hi,

Thanks for your reply, but the results that you have provided are not what I wanted? I was expected to see the following results, basically I want to see how many working days are between DateEntered and DateInvoiced and to exclude the holidays from the result set.

OrderId	DateEntered	DateInvoiced	DaysOld
1	01/05/2013	01/07/2013	42
2	09/12/2013	22/01/2014	30
3	22/03/2014	22/03/2014	0
4	12/12/2013	25/03/2014	71
5	24/12/2013	24/12/2013	1
6	24/12/2013	30/12/2013	3
7	25/12/2013	02/01/2014	4

Thanks

Re: NetworkDays script

maxgro — Wed, 26 Mar 2014 22:35:41 GMT

see attachment, this is the RESULT

using your qvw

and variable h =chr(39) & concat(Holidays, chr(39) & ',' & chr(39)) & chr(39)

and expression =NetWorkDays(DateEntered, DateInvoiced, $(h))