topic Re: Network days syntax help in QlikView

Network days syntax help

Sun, 15 Sep 2013 21:12:53 GMT

hi i am currently stuck with a problem whereby i find no solution myself.

the situation is that i cannot deduct the weeekend days from my total.

i am using the following script without success;

=Sum({<Date2={">=$(=date#(%DatXX_Ölev,'YYYY-MM-DD'))<=$(=date#(%DatXX_Lev,'YYYY-MM-DD'))"},isWeekday={1}>}Date2)

i have attached my example.

anyhelp would be greatly appreciated.

Best

Brad

Re: Network days syntax help

Oleg_Troyansky — Mon, 16 Sep 2013 05:56:04 GMT

Didn't you want to COUNT dates, instead of using SUM?

Re: Network days syntax help

tresB — Mon, 16 Sep 2013 07:35:58 GMT

Hello Brad,

Though i am not clear about your requirement, there is a function, networkdays() in qv, which excludes weekends with some more flexibility. Have you tried that? And yes, as suggested by Oleg Troyansky, you might want to use count() instead of sum().