topic Re: NetWorkDay expression not picking correct information in QlikView

NetWorkDay expression not picking correct information

Thu, 30 Jul 2015 10:11:26 GMT

Hello,

I am new to QlikView.I want to calculate Total networkdays for my Dashboard.I want to show the number of days.

I have following data:

Start date

End date

For holidays i createed a variable vHoliday and run script

set vHoliday =
'2011/01/01',
'2011/03/21',
'2011/04/22',
'2015/04/06',
'2015/04/27',
'2015/05/01',
'2015/06/16',
'2015/08/09',
'2015/08/10',
'2015/09/24',
'2015/12/16',
'2015/12/25',
'2015/12/26';

Total=

NetWorkDays(Start date,End date,$(vHoliday))

but its Returning 0 as Total value.

What is the problem with this expression here.pls suggest.

Thank you.

Re: NetWorkDay expression not picking correct information

alexandros17 — Thu, 30 Jul 2015 10:24:42 GMT

The dates are not recognized correctly as date format

Re: NetWorkDay expression not picking correct information

sushil353 — Thu, 30 Jul 2015 10:27:38 GMT

Hi,

Cross check your startdate and enddate format..

Re: NetWorkDay expression not picking correct information

tresB — Thu, 30 Jul 2015 10:29:03 GMT

Try to share your sample qvw that demonstrates the issue.

Re: NetWorkDay expression not picking correct information

sasiparupudi1 — Thu, 30 Jul 2015 10:41:37 GMT

try putting your holiday in online

set vHoliday ="'2011/01/01','2011/03/21','2011/04/22','2015/04/06','2015/04/27','2015/05/01','2015/06/16','2015/08/09','2015/08/10','2015/09/24','2015/12/16','2015/12/25','2015/12/26'";

HTH

Sasi

Re: NetWorkDay expression not picking correct information

Thu, 30 Jul 2015 11:05:21 GMT

Thank u.It was in different format.I converted it to Start Date and End Date format to $vHoliday format.Then it Worked.

But i have one more Question why cant i change $vHoliday format to Start Date and End Date format.

below :

==NetWorkDays([Start Date],[Exp End Date],(Date(Date#($(vHoliday)),'YYYY/MM/DD'),'DD/MM/YYYY'))

Re: NetWorkDay expression not picking correct information

jonathandienst — Thu, 30 Jul 2015 11:17:36 GMT

vHoliday is not a date, it is a list of dates. The Date# and Date functions accept a single string or single number respectively and cannot process your variable.

Re: NetWorkDay expression not picking correct information

Thu, 30 Jul 2015 12:09:18 GMT

How to process that variable

Re: NetWorkDay expression not picking correct information

jonathandienst — Thu, 30 Jul 2015 12:23:24 GMT

Like this:

Let vHoliday2 = '';

For Each vDate In $(vHoliday)

Let vDate2 = Date(Date#(vDate, 'YYYY/MM/DD'), 'DD/MM/YYYY');

Let vHoliday2 = vHoliday2 & If(Len(vHoliday2) > 0, ',', '') & '''' & vDate2 & '''';

Next

Let vHoliday = vHoliday2;

Re: NetWorkDay expression not picking correct information

Thu, 30 Jul 2015 13:28:28 GMT

no it didnt wort

Re: NetWorkDay expression not picking correct information

Thu, 30 Jul 2015 13:32:51 GMT

i couldnt get it .pls describe it.i m new to qlikview

Re: NetWorkDay expression not picking correct information

sasiparupudi1 — Thu, 30 Jul 2015 13:35:46 GMT

SET DateFormat='YYYY/MM/DD';

let Startdate='2015/06/01';

let Enddate='2015/07/01';

set vHoliday ="'2011/01/01','2011/03/21','2011/04/22','2015/04/06','2015/04/27','2015/05/01','2015/06/16','2015/08/09','2015/08/10','2015/09/24','2015/12/16','2015/12/25','2015/12/26'";

//set vHoliday ="'2015/12/25','2015/12/26'";

Total=NetWorkDays(Startdate,Enddate,$(vHoliday))

Total should be 22

HTH

Sasi