Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Support Case Portal has moved to Qlik Community! Read the FAQs to start exploring Support resources.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

find No. of non working days between two dates

Hello Friends,

I want the no. of non working days between two dates.

I know we can find no. of working days using NetWorkDays function. but this function returns only working working days which i don't want. I want only no. of non working days.

actuall i want to discard bank holidays and weekend between two dates difference.

Please help.

Thanks

Dipak

1 Solution

Accepted Solutions
alexandros17
Partner
Partner

You don't have to attach weekend dates because "NetWorkDays" yet exclude them, so your expression will be:

Suppose yìthat you want to analysìze all 2013:



Num('31/12/2013'-'01/01/2013'+1-NetWorkDays('01/01/2013','31/12/2013', all your holydays date)

View solution in original post

4 Replies
alexandros17
Partner
Partner

num

('30/06/2013'-'01/06/2013') +1

-
NetWorkDays('01/06/2013', '30/06/2013', '02/06/2013')

Not applicable
Author

Thank you for reply.

yes it will helpful. Actually i have list of bank holidays with comma seprator but i also want to attach weekend dates between two dates in this list. Can you please help me in this?

Thanks

alexandros17
Partner
Partner

You don't have to attach weekend dates because "NetWorkDays" yet exclude them, so your expression will be:

Suppose yìthat you want to analysìze all 2013:



Num('31/12/2013'-'01/01/2013'+1-NetWorkDays('01/01/2013','31/12/2013', all your holydays date)

View solution in original post

Not applicable
Author

Thank you very much. It will help me.