Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Support Case Portal has moved to Qlik Community! Read the FAQs to start exploring Support resources.
cancel
Showing results for 
Search instead for 
Did you mean: 
vinod1992
Contributor
Contributor

Calculation of Networkingdays for Current Month

Hi All,

I have 5 months of data and I want to calculate the Networkingdays of current month.

How can I do it?

Please help me out with your valuable suggestions.

 

Thanks & Regards,

Vinod

1 Solution

Accepted Solutions
Channa
Specialist III
Specialist III

use NetworkingDays function

 

like

=NetWorkDays(MonthStart(Today()),MonthEnd(Today()))

if you have public holidays add all holidays into variable 

=NetWorkDays(MonthStart(Today()),MonthEnd(Today()),Variable)

Channa

View solution in original post

2 Replies
Channa
Specialist III
Specialist III

use NetworkingDays function

 

like

=NetWorkDays(MonthStart(Today()),MonthEnd(Today()))

if you have public holidays add all holidays into variable 

=NetWorkDays(MonthStart(Today()),MonthEnd(Today()),Variable)

Channa

View solution in original post

vinod1992
Contributor
Contributor
Author

Thanks Channa it worked