excluding holidays for count and result in days

[#1]

hi guys,

PFA Data,

this is regarding the holiday skipping calculation.

conditions:

1.need to skip all weekneeds & public holidays for calculation.

2.14/04/2017 09:35:37 -- is holiday..so need to skip these hours.

3.04/03/2017 23:59:38 -- is holiday..so need to skip these hours.

4.14/04/2017 & 17/04/2017 both are holidays so need to skip these hours.

thanks

[vinieme12]

Use NetworkDays()

networkdays - script and chart function ‒ Qlik Sense

[#3]

hi,thanks..as we know net workdays only exclude weekends but in my case need to exclude public holidays(some times those are week days).

by creating a flag for holiday and i tried to exclude all those days but if a ticket is created yesterday and closed today(we can assume today is holiday then i need to consider working hours of yesterday only--this is the major problem)

any help!

[el_aprendiz111]

Hi,

1 Example:

SET vDayOthers = '14/04/2017', '06/03/2017';


LOAD TicketNumber,
OpenDate,
OpenDateFraction,
ClosedDate,
ClosedDateFraction,
Holidaycount,
Present_Output,
Expected_Output,
Comments
FROM
Dataissue.xlsx (ooxml, embedded labels, table is Sheet1)

Where NetWorkDays(ClosedDate, ClosedDate,$(vDayOthers))

;

[#5]

not helped,

any help guys.

[el_aprendiz111]

Hi,

Would you be able to share a sample with the expected output?