Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

net workdays

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?

2 Replies
Gysbert_Wassenaar

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?


talk is cheap, supply exceeds demand
arvind_patil
Partner - Specialist III
Partner - Specialist III

Hi Rajashmita,

Your expression required holiday list .

If you check below thread you will get idea.

https://help.qlik.com/en-US/sense/June2018/Subsystems/Hub/Content/Scripting/DateAndTimeFunctions/net...

networkdays ('7/12/2016', '1/1/2017', '31/12/2016', '25/12/2016')


Undeline part is list of holiday,


Thanks,

Arvind Patil