topic Re: Calculation based on Business days only help! in QlikView

Calculation based on Business days only help!

amit_saini — Wed, 20 May 2015 10:28:43 GMT

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

Re: Calculation based on Business days only help!

Wed, 20 May 2015 10:43:43 GMT

Hi,

You can use NetWorkDays Function.

Re: Calculation based on Business days only help!

amit_saini — Wed, 20 May 2015 10:49:11 GMT

Nandkishor,

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

Thanks,
AS

Re: Calculation based on Business days only help!

tresB — Wed, 20 May 2015 10:55:22 GMT

May be like:

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

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

floor(

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

)

Re: Calculation based on Business days only help!

amit_saini — Wed, 20 May 2015 11:13:56 GMT

Thanks Tresesco