Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Live chat with experts, bring your API Integration questions. June 15th, 10 AM ET. REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
manojkulkarni
Partner
Partner

Nth Day from Calender

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.

10 Replies
sunny_talwar

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

manojkulkarni
Partner
Partner
Author

August 1st

arvind_patil
Partner
Partner

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

sunny_talwar

May be like this

=HolidayDate - MonthStart(HolidayDate) + 2

manojkulkarni
Partner
Partner
Author

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

manojkulkarni
Partner
Partner
Author

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.

sunny_talwar

May be use LastWorkDay function...

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

You can supply the list of holidays in there as well

lastworkdate ‒ QlikView

manojkulkarni
Partner
Partner
Author

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

sunny_talwar

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