topic Re: Working days in QlikView

Working days

Fri, 12 Dec 2014 11:31:56 GMT

How to calculate workingdays between startdate and enddate? And if enddate is null,it should consider todays date.

tresB — Fri, 12 Dec 2014 11:32:41 GMT

Try networkdays().

maleksafa — Fri, 12 Dec 2014 11:33:26 GMT

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

Fri, 12 Dec 2014 11:33:53 GMT

Hi Ramya

Try this

Floor(Interval(StartDate-EndDate,'DD')) -> For Days

Hope it helps

Fri, 12 Dec 2014 11:41:55 GMT

Hi Ramya,

as a few others have said, have a look at networkdays(), you can do a check for nulls within that and use today instead

networkdays([startdate], If(isnull([enddate]),today(),[enddate]))

hope that helps

Joe

MarcoWedel — Fri, 12 Dec 2014 11:43:29 GMT

=NetWorkDays(startdate, Alt(enddate, Today()))

Fri, 12 Dec 2014 11:49:33 GMT

you will have to play about a bit, interval is good, but you may have to convert to date & time as required ...

MK_QSL — Fri, 12 Dec 2014 12:06:49 GMT

=NetWorkDays(StartDate, IF(IsNull(EndDate) or Len(Trim(EndDate))=0,Today(),EndDate))

Anonymous — Fri, 12 Dec 2014 12:12:21 GMT

What to be done if the Week offs are different from Saturdays and Sundays??????????????