Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
smitaranikr04
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
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
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