Qlik Community

Suggest an Idea

Vote for your favorite Qlik product ideas and add your own suggestions.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING

NetWorkDays configurable weekend

Larry_Aaron
Employee
Employee

NetWorkDays configurable weekend

Update the NetWorkDays function so the weekends are configurable similar to Excel.  NETWORKDAYS. INTL calculates work days between two dates. Work days exclude weekends (Saturday and Sunday by default) and can optionally exclude holidays. This function is more robust that the Qlik NETWORKDAYS function, because it allows you to control which days of the week are considered weekends.  Client has up to three shifts per day and working days of 5, 6, and 7 days per week and holidays.

Tags (2)
1 Comment
Ian_Crosland
Employee
Employee
 
Status changed to: Open - Collecting Feedback