topic Re: Time issue in QlikView

Time issue

Fri, 30 Aug 2013 12:37:23 GMT

Good day,

a company is open from 07:00 to 13:00 and trucks deliver goods only between these times

So there is a column Total Time spent, which is the total time a truck spent @ the company, even if it was closed.

The column Actual time spent must show the time that the truck spent @ the company between 07:00 and 13:00

Thus

Truck one, actual time spent should be 02:00 which is good,

Truck two, actual time spent should be 02:00 (09:00 minus 07:00 (open time))

Truck three, actual time should be 03:00 (10:00 minus 07:00 (open time))

Please see attached

Re: Time issue

Fri, 30 Aug 2013 13:02:48 GMT

Hi,

Please Find the attached file . Hope it will helps you

Re: Time issue

CELAMBARASAN — Fri, 30 Aug 2013 13:11:09 GMT

May be attached file might helps

Re: Time issue

Mon, 02 Sep 2013 05:32:30 GMT

Hi,

This is helpful, but what happens if the truck arrives at 12:30 PM, and departs at 13:30 PM,

Then the answer will be 13:30 - 07:00 = 6:30, but it should be 30 minutes.

Regards

Re: Time issue

Mon, 02 Sep 2013 05:37:46 GMT

Hi,

I like the expression, its a little complicated though.

The answer for the last one should be 03:00 though, is that possible?

Regards

Re: Re: Time issue

jagan — Mon, 02 Sep 2013 06:02:58 GMT

Hi,

PFA for solution.

Regards,

Jagan.

Re: Re: Time issue

Mon, 02 Sep 2013 07:01:24 GMT

Hi Jagan,

Please see attached under new discussion called time issue 1, I added some more data to the model you sent me, but its still incorrect. I also added a column with the correct answers.

Regards