Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

vinod1992
New 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
Valued Contributor III

Re: Calculation of Networkingdays for Current Month

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
2 Replies
Channa
Valued Contributor III

Re: Calculation of Networkingdays for Current Month

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
vinod1992
New Contributor

Re: Calculation of Networkingdays for Current Month

Thanks Channa it worked