topic Re: NetWorkDays function in QlikView

NetWorkDays function

Mon, 31 Dec 2012 16:06:13 GMT

Hi,

I'm facing an issue with NetWorkDays function.

When I'm using this expression: =NetWorkDays('11/12/2012','04/03/2013')

the result is 60, which is correct.

But when I'm using: =NetWorkDays('04/03/2013','11/12/2012')

The fuction returns 0, and I need it to return (-60).

How can I get (-60) instead of 0?

Thanks,

Aviad

Re: NetWorkDays function

shree909 — Mon, 31 Dec 2012 17:19:00 GMT

Hi try this

NetWorkDays(floor(('04/03/2013','11/12/2012'))

='-' & NetWorkDays(floor(('04/03/2013','11/12/2012')

Re: NetWorkDays function

Fri, 04 Jan 2013 06:29:41 GMT

Hi,

Networkdays function would not return negative result,but 0.

In such a case,

Consider the below example,where I have a startdate and enddate

Data:

LOAD * INLINE
[
EmplNo,Amount,StartDate,EndDate
001,129.000,11/12/2012,12/15/2012
002,130.000,12/12/2012,12/15/2012
003,154.000,01/01/2013,05/01/2013
004,186.000,12/01/2013,12/01/2013
005,169.000,01/25/2013,01/27/2013
];

EmplNo	Amt	StartDate - EndDate	EndDate-StartDate
		-	-
001	129	25	-25
002	130	3	-3
003	154	87	-87
004	186	0	0
005	169	1	-1

For achieving (StartDate - EndDate) column result use the expression :

=NetWorkDays

(StartDate,EndDate)

For achieving (EndDate-StartDate) column result use the expression :

=NetWorkDays(StartDate,EndDate) * -1

Hence, you get the desired result.

Regards,
Snehal Nabar

Re: NetWorkDays function

Fri, 04 Jan 2013 06:38:17 GMT

Hi aviad_we,

Please mark this post as answered,if your query is solved.

Regards,

Snehal Nabar