topic Calender Effect in QlikView

Calender Effect

Mon, 12 Mar 2012 11:41:16 GMT

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

Calender Effect

swuehl — Mon, 12 Mar 2012 11:46:36 GMT

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

Calender Effect

Mon, 12 Mar 2012 12:14:11 GMT

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.

Calender Effect

swuehl — Mon, 12 Mar 2012 12:16:43 GMT

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