Skip to main content
Announcements
See why Qlik is a Leader in the 2024 Gartner® Magic Quadrant™ for Analytics & BI Platforms. Download Now
cancel
Showing results for 
Search instead for 
Did you mean: 
mdmukramali
Specialist III
Specialist III

DURATION BY EXCLUDING WEEKDAYS AND HOLIDAYS

Dear All,

In My table i have REQUEST_NO ,REQUEST_START_DATE AND REQUEST_END_DATE .

By using Interval match function i calculated the DURATION to complete the REQUEST.

but i want to exclude the Weekdays from DURATION.  in my case Friday and Saturday are weekdays (holidays) . Sunday is the first day of my week.

I tried Networkdays() function but i didn't succeed to achieve the desired result.

Kindly find the attached sample file,

please help me to solve the my problem.

Thanks,

Mukram.

1 Reply
maxgro
MVP
MVP

maybe with networkdays(REQUEST_START_DATE+1, REQUEST_END_DATE+1)

+1 to adapt your weekdays (friday and saturday) to "standard" (saturday and sunday) weekdays