topic Re: Urgently! The number of days between two dates without exception from the list. in QlikView

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

warfollowmy_ver — Thu, 09 Feb 2017 10:34:39 GMT

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

swuehl — Thu, 09 Feb 2017 10:42:35 GMT

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 — Thu, 09 Feb 2017 10:44:03 GMT

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 — Thu, 09 Feb 2017 10:52:37 GMT

See the attachment, imagine that the 50 million lines

warfollowmy_ver — Thu, 09 Feb 2017 10:52:43 GMT

See the attachment, imagine that the 50 million lines

sdmech81 — Thu, 09 Feb 2017 11:47:51 GMT

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 — Thu, 09 Feb 2017 11:49:29 GMT

Anothr condion in else should be like:

Simple date of code- start date.

Sachin

sdmech81 — Thu, 09 Feb 2017 11:50:25 GMT

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

Sachin