Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Net work Days in current month

Hi Guys

I want to count average sales per day. I am counting total sales for the current month by using following expression.

=Count(DISTINCT(if(Month([Completion Date]) = Month(Today()), OrderId)))

How to get number of total working days in present month? to divide with above expression

Thanks

1 Solution

Accepted Solutions
sunny_talwar

May be this:

NetWorkDays(Floor(MonthStart(Today())), Today())

View solution in original post

7 Replies
sunny_talwar

May be like this:

NetWorkDays(Floor(MonthStart(Today())), Floor(MonthEnd(Today())))

Not applicable
Author

Thanks Sunny...

Your expression is giving me total as 23

how do I exclude weekends?

thanks

sunny_talwar

I think weekends are already excluded here

sunny_talwar

I see 23 weekdays in the month of August

Capture.PNG !

Not applicable
Author

Because today is 23 August and if you subtract 6 weekends then it should give you total as 17 !

Not applicable
Author

oh now i got your point lol... i wanted MTD weekedays

sorry for confusion

sunny_talwar

May be this:

NetWorkDays(Floor(MonthStart(Today())), Today())