How to exclude WeekOffs / Non Working Hours

[khanashique]

Hi,

Need to Exclude WeekOffs / Non Working Hours from Days / Time Calculations:

Example:

Working Day --> Monday to Friday Week Off Day --> Saturday and Sunday

Shifts Hours --> 07:30 AM to 05:30 PM

So the time calculation should exclude the days and hours other than working day and shift hours.

Thanks,

MAK.

[Digvijay_Singh]

networkdays function can help in these situations may be -

https://help.qlik.com/en-US/sense/November2017/Subsystems/Hub/Content/Scripting/DateAndTimeFunctions...

[khanashique]

Hi,

Thanks for the quick reply, but is there any simple / easy way to exclude the non working hours / weekoffs.

Because here the link (https://help.qlik.com/en-US/sense/November2017/Subsystems/Hub/Content/Scripting/DateAndTimeFunctions...)

which you have provided, can help for small amount of data, how can one exclude the holidays/weekoffs for whole year/s for example:

1 Week = 2 WeekOffs. So, In a month it comes 8 WeekOffs and if if we take a look for whole year, we get 96 WeekOffs, so this is not practically correct to put whole 96 weekoffs as holidays.

There should be a simplest way to define somewhere in AutoCalendar. So, the Calendar it self exclude the weekoffs/holidays/non working hours.

Thanks,

MAK.

[Digvijay_Singh]

you don't need to mention explicitly the weekends, Sat and Son. By default it exclude weekends. You need to mention holidays other than Sat and Sun if you want to as 3rd,4th..so on parameters.

[khanashique]

Hi Thanks once again,

The above function works for excluding the weekoffs/holidays but what about the non working hours to exclude from total hours.

Thanks,

MAK.