Skip to main content
Announcements
Sept. 27, 10AM ET Do more with Qlik, Insight Advisor – our intelligent AI-assistant in Qlik Sense: Register
cancel
Showing results for 
Search instead for 
Did you mean: 
warfollowmy_ver
Creator III
Creator III

Urgently! The number of days between two dates without exception from the list.

!It is necessary to count the number of days between two dates with the exception of the dates in the list.

NetWorkDays is not suitable because it excludes Saturdays and Sundays, and that if the company sometimes works on Saturday and Sunday.

That is, I need to calculate the days between two dates excluding dates only from my list.

7 Replies
swuehl
MVP
MVP

A possible approach would be to create a master calendar, flag the dates you want to include / exclude in your calculation.

Then count the flagged dates in the master calendar that fall between the two dates.

sdmech81
Specialist
Specialist

May be like:

U convert you both dates in to number and deduct them.

And then take the count of days from ur list and again deduct from above result.

Sachin

warfollowmy_ver
Creator III
Creator III
Author

See the attachment, imagine that the 50 million lines

warfollowmy_ver
Creator III
Creator III
Author

See the attachment, imagine that the 50 million lines

sdmech81
Specialist
Specialist

May be something like this with new column u can try:

=if(weend or holiday<=Date of code,(num(date of code)-num(date start)-count(weekend or holiday)))

Plss alter if condtn as per need.

Sachin

sdmech81
Specialist
Specialist

Anothr condion in else should be like:

Simple date of code- start date.

Sachin

sdmech81
Specialist
Specialist

While u try u use num() on all date fileds n compare.

Sachin