Nth Day from Calender

[manojkulkarni]

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.

[#2]

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.