topic net workdays in QlikView

net workdays

Anonymous — Thu, 12 Jul 2018 07:43:36 GMT

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?

Re: net workdays

Gysbert_Wassenaar — Thu, 12 Jul 2018 08:00:37 GMT

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?

Re: net workdays

arvind_patil — Thu, 12 Jul 2018 08:01:27 GMT

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/networkdays.htm

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

Undeline part is list of holiday,

Thanks,

Arvind Patil