Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hey Guys,
NetWorkDays([Date],date(num(Start)-1))
here Date =7/12/2016 and Start=1/2/2017 but I am getting 124 as a output of the above expression, but this is wrong different workindays between these days are not 124.
Can please anyone help me?
Perhaps there's something wrong with one of your dates. I get 146 working days as a result.
Can you post a small qlikview document that demonstrates the problem?
Hi Rajashmita,
Your expression required holiday list .
If you check below thread you will get idea.
networkdays ('7/12/2016', '1/1/2017', '31/12/2016', '25/12/2016')
Undeline part is list of holiday,
Thanks,
Arvind Patil