topic Re: How to exclude WeekOffs / Non Working Hours in QlikView

How to exclude WeekOffs / Non Working Hours

khanashique — Sun, 25 Mar 2018 13:57:48 GMT

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.

Re: How to exclude WeekOffs / Non Working Hours

Digvijay_Singh — Sun, 25 Mar 2018 14:07:48 GMT

networkdays function can help in these situations may be -

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

Re: How to exclude WeekOffs / Non Working Hours

khanashique — Sun, 25 Mar 2018 14:28:22 GMT

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/networkdays.htm?_ga…)

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.

Re: How to exclude WeekOffs / Non Working Hours

Digvijay_Singh — Sun, 25 Mar 2018 15:15:09 GMT

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.

Re: How to exclude WeekOffs / Non Working Hours

khanashique — Mon, 26 Mar 2018 09:00:22 GMT

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.