topic Re: Nerwork days function in QlikView

Nerwork days function

Tue, 05 Apr 2016 08:40:31 GMT

Hi All,

I have start date and end date from which I want to calculate the number of days excluding week ends and holidays, but my week ends are not Saturday and Sunday, it is Thursday and Friday, hence I am not able to use network days function here. Can anyone help with alternative.

Re: Nerwork days function

Kushal_Chawda — Tue, 05 Apr 2016 08:42:03 GMT

I think this is quite similar to below

Networkdays function to change non working days from saturday-sunday to thursday-friday

Re: Nerwork days function

marcus_sommer — Tue, 05 Apr 2016 08:43:48 GMT

Maybe this is helpful: NetWorkDays: Excluding Friday and Saturday between two dates

- Marcus

Re: Nerwork days function

buzzy996 — Tue, 05 Apr 2016 08:59:53 GMT

can u try this way,

define all ur holidays,like belwo..

Holidays:

LOAD * INLINE [

Holiday

01/01/2005

02/01/2005

08/01/2005

....etc

];

load

concat(chr(39) & Holiday & chr(39),',') as list

Resident Holidays;

LET ListOfHolydays = Peek('list');

and use expression like this on ur chart?

Count(If(Networkdays(Column1,column2,$(ListOfHolydays))<'6',column3))

HTH