current working day count

[yoganantha321]

Hi,

I need a expression how to calculate the working day in month.

Example:

April- 23

May- 3 (as of today three working days)

If I see tomorrow it should display as

April -23

May-4 (if i see tomorrow four working days)

How can I achieve it can any body help me?

regards,

Yoganantha Prakash G P

[MindaugasBacius]

Let's assume you have a flag field like [Working day]:

1. 1 - stands for working day

2. 0 - it 's not a working day

Then try this:

Sum({<Date = {"<=$(=Today())"}>} [Working day])

As dimension use  [Year, month]

[sunny_talwar]

What defines a workday? Monday to Friday? and do you have a list of holidays you would want to exclude?

[yoganantha321]

Monday to Friday only Sunny

[swuehl · Accepted solution]

Something like

=NetWorkDays(Monthstart(today()), today() )

https://help.qlik.com/de-DE/qlikview/12.0/Subsystems/Client/Content/Scripting/DateAndTimeFunctions/n...

[avinashelite]

Then use the networkingday() function

networkdays (start:date, end_date {, holiday})

Returns the number of working days (Monday-Friday) between and including start_date and end_date taking into account any optionally listed holidays. All parameters should be valid dates or timestamps.

Examples:

networkdays ('2007-02-19', '2007-03-01') returns 9 

networkdays ('2006-12-18', '2006-12-31', '2006-12-25', '2006-12-26') returns 8 

[yoganantha321]

thanks stefan

[shiveshsingh]

networkdays(monthstart(today()), today)