net workdays

[Anonymous]

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?

[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?

[arvind_patil]

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