Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Posting on Qlik Community is temporarily paused. Thank you for patience and we'll update you soon!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

NetWorkDay expression not picking correct information

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.

Labels (1)
11 Replies
Not applicable
Author

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

sasiparupudi1
Master III
Master III

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