topic Re: Nth Day from Calender in QlikView

Nth Day from Calender

manojkulkarni — Wed, 25 Nov 2020 16:16:04 GMT

Hi Friends,

I need to identify nth working day in a calender for month, how can we achieve this ? Is there any built in functions available to identify ?

eg:

15th Day of August, which is Holiday so i should get out put as 16.

Re: Nth Day from Calender

sunny_talwar — Fri, 28 Jul 2017 12:00:07 GMT

Which day are you comparing this to get 16? August 1st or July 31st?

Re: Nth Day from Calender

manojkulkarni — Fri, 28 Jul 2017 12:06:39 GMT

August 1st

Re: Nth Day from Calender

arvind_patil — Fri, 28 Jul 2017 12:10:49 GMT

Hi Manoj,

You have to pass master to the database where you need to pass all dates which have a holiday.

Then after you can achieve this.

Thanks,

Arvind Patil

Re: Nth Day from Calender

sunny_talwar — Fri, 28 Jul 2017 12:14:37 GMT

May be like this

=HolidayDate - MonthStart(HolidayDate) + 2

Re: Nth Day from Calender

manojkulkarni — Fri, 28 Jul 2017 12:14:57 GMT

Is there any function available which could return me the date as weekend or holiday else return me the next working day ?

Re: Nth Day from Calender

manojkulkarni — Fri, 28 Jul 2017 12:29:55 GMT

Hi Sunny,

I think my question was not clear.

I am trying to get 12th day of month for calculation purpose, if 12th day of month falls on weekend /holiday then i should look for next working day.

Re: Nth Day from Calender

sunny_talwar — Fri, 28 Jul 2017 12:32:43 GMT

May be use LastWorkDay function...

=LastWorkDate(MonthStart(Today(), 1), 12)

You can supply the list of holidays in there as well

lastworkdate ‒ QlikView

Re: Nth Day from Calender

manojkulkarni — Fri, 28 Jul 2017 12:36:30 GMT

This will exclude weekends. I need irrespective of weekends, 12th day of Month. Only if 12th days falls on weekend then look for next date

Re: Nth Day from Calender

sunny_talwar — Fri, 28 Jul 2017 12:42:49 GMT

I don't think there is a function available for this... you can use a nested if statement to check for weekends

Re: Nth Day from Calender

Fri, 28 Jul 2017 12:48:17 GMT

Manoj, you can create your own logic in the expression to get the desired output.

As of my knowledge, there is no direct Qlik function available to get what you need.

if( WeekDay(makedate(2017,08,12)) < 5, makedate(2017,08,12), makedate(2017,08,12)+1)

The above is the sample expression and you can tweak it to your needs.