Previous Business Day excluding holidays?

[#1]

Finding logic to show last working week day for week over week comparison and similarly finding last working day for month over month comparison?

find previous business day(Working day), excluding holiday, and if the week end is a public holiday then it should get next previous available date.

If i am processing Monday, I should get Friday as working day, if Friday is holiday then I should get Thursday as working day.

Right now, I am using count({$(vsetcurrentweek)>}Fl_Volume_Flag) which is all about current week.

Any help???

Thank you

[robert_mika]

Try FirstWorkingDate

Using FirstWorkDate() function in QlikView - QlikView Blog, QlikView Videos and Tips at QlikShare

[Anonymous]

You can use firstworkdate.

From QV help:

Firstworkdate(end_date, no_of_workdays {, holiday} )

Returns the latest starting date to achieve number_of_workdays (Monday-Friday) ending no later than end_date taking into account any optionally listed holidays. End_date and holiday should be valid dates or timestamps.

Examples:

firstworkdate ('2007-03-01', 9) returns '2007-02-19' 

firstworkdate ('2006-12-31', 8, '2006-12-25', '2006-12-26') returns '2006-12-18' 

[#4]

Thank you

[robert_mika]

You are welcome.

Please mark this question as answered