Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

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]

Tags (1)
1 Solution

Accepted Solutions
Highlighted
cesaraccardi
Valued Contributor

Re: # of Working Days MTD

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 ]'

1 Reply
Highlighted
cesaraccardi
Valued Contributor

Re: # of Working Days MTD

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 ]'