topic Re: current working day count in QlikView

current working day count

yoganantha321 — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: current working day count

MindaugasBacius — Wed, 03 May 2017 13:28:30 GMT

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]

Re: current working day count

sunny_talwar — Wed, 03 May 2017 13:50:12 GMT

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

Re: current working day count

yoganantha321 — Wed, 03 May 2017 13:56:39 GMT

Monday to Friday only Sunny

Re: current working day count

swuehl — Wed, 03 May 2017 13:58:49 GMT

Something like

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

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

Re: current working day count

avinashelite — Wed, 03 May 2017 14:01:14 GMT

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

Re: current working day count

yoganantha321 — Wed, 03 May 2017 14:16:26 GMT

thanks stefan

Re: current working day count

shiveshsingh — Wed, 03 May 2017 15:57:25 GMT

networkdays(monthstart(today()), today)