Qlik Community

Ask a Question

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Talk to Experts Tuesday, January 26th at 10AM EST: Qlik Sense. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Creator
Creator

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
MVP & Luminary
MVP & Luminary

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
Partner
Partner

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