Calender Effect

[#1]

Hi!

While calculating difference between two dates  dont  want to consider the weekends and holidays(which will be uploaded by an excel).

Can some one let me know how to go a'bt it.

thanks

[swuehl]

I think you may want to look into networkdays() function:

networkdays(start:date, end_date {, holiday})

Returns the number of working days (Monday-Friday) between and including start_date and end_date taking into account any optionally listed holidays. All parameters should be valid dates or timestamps.

Examples:

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

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

[#3]

hi!

thanks

i have a list of holidays, which i have to consider to do this calculation. I am uploading it through excel.

I think this function can help only for a single holiday.

[swuehl]

No, you can load your holidays from a table and use them in the function.

There are some examples here in the forum on how to do that, e.g.:

http://community.qlik.com/message/90025