topic Re: Date: Identify Next working day in QlikView

Date: Identify Next working day

manojkulkarni — Fri, 04 Nov 2016 07:00:41 GMT

HI Team,

I have requirement in which we need to exclude weekends & holidays while deriving the new transaction date.

eg; I have data received today but due to cutoff time we need to push it for next day. While calculating new date weekends & holidays needs to be ignored.

Request members to provide suggestions to implement. If anybody has already done similar then please share the code.

Thanks in Advance

Re: Date: Identify Next working day

sushil353 — Fri, 04 Nov 2016 07:11:23 GMT

Hi,

You can use Weekday() function.. something like this:

if(WeekDay(Datefield)<5,Datefield,weekstart(Datefield,1))

HTH

Re: Date: Identify Next working day

manojkulkarni — Fri, 04 Nov 2016 07:18:26 GMT

Thanks for quick reply.

We can use this function to identify week end & weekday. But my requirement is for any given date i should be able to provide next working day ,should exclude Saturday, Sunday & Holidays if any.

eg 4th Nov is Friday, next working for this date is 7th Nov Again if 7th is holiday then it should give me 8th Nov.

Re: Date: Identify Next working day

tresB — Fri, 04 Nov 2016 07:35:38 GMT

LastWorkDate()

Re: Date: Identify Next working day

manojkulkarni — Fri, 04 Nov 2016 08:22:48 GMT

Thanks, but this function requires "no_of_workdays" which cann't be defined

Re: Date: Identify Next working day

sushil353 — Fri, 04 Nov 2016 08:36:09 GMT

Weekstart(Datefield,1) have offset 1 which will force the startdate to be next week's first working date.. for example

Re: Date: Identify Next working day

tresB — Fri, 04 Nov 2016 08:48:41 GMT

Try 'no_of_workdays' as 1.

Re: Date: Identify Next working day

krishna20 — Fri, 04 Nov 2016 09:11:32 GMT

for that you please prepare one master which contains all hoilidays

and bring that into application then avoid these days in application

Re: Date: Identify Next working day

Anonymous — Fri, 04 Nov 2016 14:02:20 GMT

If(Match(WeekDay(DateField),'Sat','Sun'),LastWorkDate(DateField,1,YourHolidayList),LastWorkDate(DateField+1,1,YourHolidayList))

Re: Date: Identify Next working day

enozagar — Mon, 28 Oct 2024 13:22:22 GMT

firstworkdate(end_date, no_of_workdays {, holiday} )

https://help.qlik.com/en-US/sense/May2024/Subsystems/Hub/Content/Sense_Hub/Scripting/DateAndTimeFunctions/firstworkdate.htm

Best regards

Davide

Re: Date: Identify Next working day

enozagar — Mon, 28 Oct 2024 13:25:53 GMT

lastworkdate(start_date, no_of_workdays {, holiday})

https://help.qlik.com/en-US/sense/May2024/Subsystems/Hub/Content/Sense_Hub/Scripting/DateAndTimeFunctions/lastworkdate.htm