Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
amit_saini
Master III
Master III

Calculation based on Business days only help!

Hi Folks ,

Below is my calculated expression for Ticket Age :

=if(IsNull(if(%ClosedDate < 2958465, date(%ClosedDate))),floor(today()-(date(%OpenedDate))),floor((if(%ClosedDate < 2958465, date(%ClosedDate)))-(date(%OpenedDate))))

Now my requirement is not to include Sat, Sun in this calculation , want Ticket Age based on only 5 working days.

Kindly suggest!

Thanks,
AS

1 Solution

Accepted Solutions
tresesco
MVP
MVP

May be like:

if(IsNull(if(%ClosedDate < 2958465, date(%ClosedDate))),

floor(Networkdays((date(%OpenedDate),today()))),

floor(

   (if(%ClosedDate < 2958465, Networkdays(date(%OpenedDate),date(%ClosedDate))))

  )

)

View solution in original post

4 Replies
Not applicable

Hi,

You can use NetWorkDays Function.

amit_saini
Master III
Master III
Author

Nandkishor,

I have already tried this but getting ' - ' values.

Thanks,
AS

tresesco
MVP
MVP

May be like:

if(IsNull(if(%ClosedDate < 2958465, date(%ClosedDate))),

floor(Networkdays((date(%OpenedDate),today()))),

floor(

   (if(%ClosedDate < 2958465, Networkdays(date(%OpenedDate),date(%ClosedDate))))

  )

)

amit_saini
Master III
Master III
Author

Thanks Tresesco