topic Skip Holiday in QlikView

Skip Holiday

Thu, 03 May 2012 07:44:41 GMT

Hey

i want calculate a end date for a case which comes into the system based on its open date. but i want so skip the holidays if they fall in between.

I have the list of holidays. can some one suggest me something for this.

Skip Holiday

SunilChauhan — Thu, 03 May 2012 07:53:24 GMT

networkdays (start_date, end_date {, holiday})

example

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

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

you can add holidays seperated by comma at tha end in bracket

hope this helps

Skip Holiday

Thu, 03 May 2012 10:10:56 GMT

Hi sunil thanks for the help but , I dont have the end date, i want to calculate it using some criterias and skipping holidays, if they fall in between.

So i want some way by which i can skip the dates in my logic when holiday falls.

Skip Holiday

SunilChauhan — Thu, 03 May 2012 10:31:29 GMT

we use calculated at place of enddate

or use variable for that

hope this helps

Re: Skip Holiday

jonathandienst — Thu, 03 May 2012 10:43:26 GMT

I think what you are looking for is

LastWorkDate(<startdate>, <number of work days>, <holiday date 1>, <holiday date 2>, ....)

I usually store a the holiday dates in a variable as a comma separated, quoted list of dates. So then I call

LastWorkDate(OpenDate, 10, $(vHolidayList))

... for the 10th working day following OpenDate (including OpenDate, if it is a work date)

Regards

Jonathan