Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to do cumputation with working days

Hello,

I want to do computations between two dates. For example:

(monday)  01.02.16   -   29.01.16  (friday).

Unfortunately the system is giving me back the result of 3 in fact that it count the weekend in between. I want to see 1 as an result if I think in working days.

Is there as easy option to tell the system to ignore sat und sun in the computation?  or the other way around on respect days from monday fto friday?

Thx for help

Heiko

2 Replies
sunny_talwar

Try this:

NetWorkDays(StartDate, EndDate)

In your case -> NetWorkDays(MakeDate(2016,1,29), MakeDate(2016,2,1))

Not applicable
Author

Hello Sunny , thx for your great help.