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

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
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.

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