Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

# of Working Days MTD

I am trying to write a formula that gives me the number of working days that the current month has already had. I would like it to be based off of the current month and not have to rely on someone selecting a date.

The Goal is to have that in a banner at the top of my dashboard so that it is a quick reference of how far we are into the month.

This is a puicture of what I am trying to build

What it needs to say though is "Current Through 08/06/12 [4 / 23 Working Days / 17% Completed]

1 Solution

Accepted Solutions
cesaraccardi
Specialist
Specialist

Hi, simply put this in a text object:

='Current Through ' & today() & ' [ ' & NetWorkDays(MonthStart(Today()),Today()) & ' / ' &

NetWorkDays(MonthStart(Today()),MonthEnd(Today())) & ' Working Days / ' &

num(NetWorkDays(MonthStart(Today()),Today())/

NetWorkDays(MonthStart(Today()),MonthEnd(Today())),'#.##0 %')

& ' Completed ]'

View solution in original post

1 Reply
cesaraccardi
Specialist
Specialist

Hi, simply put this in a text object:

='Current Through ' & today() & ' [ ' & NetWorkDays(MonthStart(Today()),Today()) & ' / ' &

NetWorkDays(MonthStart(Today()),MonthEnd(Today())) & ' Working Days / ' &

num(NetWorkDays(MonthStart(Today()),Today())/

NetWorkDays(MonthStart(Today()),MonthEnd(Today())),'#.##0 %')

& ' Completed ]'