Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
i couldnt get it .pls describe it.i m new to qlikview
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