topic Re: Time Calculation contd.. in QlikView

Time Calculation contd..

Anonymous — Wed, 16 Jul 2014 21:05:31 GMT

Dear Experts,

You guys already helped on finding the time difference between "In Process" and "Complete" for each team which worked perfect.

Need your help again.

1.There are few cases where I don't have the "In Process" status,but directly its updated as "Complete".I want to update 0 hours spent on those specific cases.Kindly help me

2.Also I want to ignore some specific hours in the calculation.i.e.We have a case ID which starts on Thursday and completed on Tuesday.I want to exclude the hours from Friday 7PM to Monday morning 8AM.

Request you to help me on these points.

Thanks & Regards

Jeba

Re: Time Calculation contd..

Anonymous — Thu, 17 Jul 2014 20:39:15 GMT

Dear Experts,

Kindly help me.

Thanks & Regards

Jeba

Re: Time Calculation contd..

Anonymous — Fri, 18 Jul 2014 13:22:20 GMT

Dear Experts,

Kindly help me.

Thanks & Regards

Jeba

Re: Time Calculation contd..

anandathome — Fri, 18 Jul 2014 13:25:31 GMT

Could you please upload your previous application so that we can have a look and understand the full story?

Re: Re: Time Calculation contd..

Anonymous — Fri, 18 Jul 2014 13:26:58 GMT

Hi Anand

PFA.

Regards

Jeba

Re: Re: Re: Time Calculation contd..

anandathome — Fri, 18 Jul 2014 14:34:14 GMT

Hi Jeba,

1. PFA for your first req.

2. For second req, something has to be done using networkdays()function.

I am looking into and will update you soon.

Re: Time Calculation contd..

Anonymous — Fri, 18 Jul 2014 14:56:08 GMT

Hi Anand,

Thanks a lot,it worked perfect.

I am also working on the networkdays function.But the thing is we need to exclude only the specific hours not the whole day.

Kindly send me if you find the solution.I will keep you posted.

Thanks & Regards

Jeba

Re: Time Calculation contd..

Anonymous — Fri, 18 Jul 2014 17:54:21 GMT

Hi Anand,

Also I need one more help.

In some cases I have two "complete" status for the same team which is logically wrong but our system accepts that.In such scenarios our time calculation goes wrong.Could you please help me in creating a code which accepts the "Complete" status for the maximum date/time.

Thanks & Regards

Jeba

Re: Time Calculation contd..

Anonymous — Tue, 05 Aug 2014 06:25:09 GMT

Hi Anand,

Did you find something for this?

Thanks & Regards

Jeba