Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

net work days

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

6 Replies
Gysbert_Wassenaar

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)

     )

)


talk is cheap, supply exceeds demand
sunny_talwar

Not the best of ways, but seems to work

Capture.PNG

Expression:

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

Anonymous
Not applicable
Author

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).

Anonymous
Not applicable
Author

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!!

Untitled.png

Anonymous
Not applicable
Author

did you check this?

NetWorkDays

Anonymous
Not applicable
Author

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. Untitled.png