topic Re: net work days in QlikView

net work days

Anonymous — Wed, 23 Dec 2015 09:40:52 GMT

Hello again,

I want to calculate the number of working days between two dates excluding Saturday only.

the function networkingdays excludes Saturday and Sunday also.

how can i do it without having a tables with records for everyday in the period. (using Join) .

Thanks,

Naor

Re: net work days

Gysbert_Wassenaar — Wed, 23 Dec 2015 17:57:25 GMT

Try this one:

Interval(

rangesum(

Date2-Date1,

-If(Weekday(Date1)=5,1),

-Div(Date2-Date1,7), -If(WeekDay(Date2)<Weekday(Date1),1), if(WeekDay(Date1)=5,1)

)

Re: net work days

sunny_talwar — Thu, 24 Dec 2015 03:37:58 GMT

Not the best of ways, but seems to work

Expression:

((Floor(WeekStart(End)) - Floor(WeekEnd(Start)) - 1) *(6/7)) + (Floor(WeekEnd(Start)) - Start) + (End - Floor(WeekStart(End)) + 1)

Re: net work days

Anonymous — Thu, 24 Dec 2015 06:10:00 GMT

Hi Gysbert ,

first of all - thank you! but unfortunately is doesn't work well - the answer between 4/1 and 1/1 shows 3 days but it should be only 1 working day (Friday).

Re: net work days

Anonymous — Thu, 24 Dec 2015 06:20:02 GMT

Hi,

take a look at the answer of the expression you suggested - (TRY11)

i'm trying to use it in the script but unfortunately is doesn't work well.

any idea?

Thanks!!

Re: net work days

Anonymous — Thu, 24 Dec 2015 06:25:29 GMT

did you check this?

NetWorkDays

Re: net work days

Anonymous — Thu, 24 Dec 2015 06:37:18 GMT

Hi Balraj,

Yes i checked it but this is what i need - full working days (means that between 13/1 and 12/1 there are 0 working days) between the rows without Saturday.