topic How to get processed time? in QlikView

How to get processed time?

Wed, 05 Mar 2014 08:08:11 GMT

Hi,

May I ask how to do the script to get the processed time for the following data below?

I wanted to get the processed time from Task received time to processed time. The condition is if Processed time-task received time<=15 minutes it is within SLA, otherwise over SLA..

Thank you!!

Regards,

-Ahyel

Re: How to get processed time?

Wed, 05 Mar 2014 08:33:10 GMT

Hi,

Try this in your load script:

LOAD ...

if(Action='PROCESSED', Interval(Time#(Time2)-Time#(Time1)) ) as Duration

....

Please adapt the field names to your model

Fabrice

Re: How to get processed time?

Wed, 05 Mar 2014 08:48:20 GMT

Hi Aunez,

Thanks for this. But how about the condition of if time2-time1<=15 minutes it is within SLA otherwise, Over SLA?

Thanks again

- Ahyel

Re: How to get processed time?

Wed, 05 Mar 2014 09:14:45 GMT

Ahyel,

if (Interval(Time#(Time2)-Time#(Time1))<=1/24/4, (Interval(Time#(Time2)-Time#(Time1)), sth else)

1 is 1 day

1/24/4 is 15 minutes

Fabrice

Re: How to get processed time?

Wed, 05 Mar 2014 09:26:05 GMT

Hi Aunez,

Okay. Can I ask how 1/24/4 become 15 minutes? Is this a standard format of time for Qlikvew?

Thank you so much!

Regards,

-Ahyel

Re: How to get processed time?

jagan — Wed, 05 Mar 2014 09:35:29 GMT

Hi,

1/24 is 1 day has 24 hours and 1/24 gives you 1 hour

(1/24)/4 - Gives you 15 minutes (1 hour = 60 mins, 60/4 = 15)

Hope this helps you.

Regards,

jagan.

Re: How to get processed time?

Wed, 05 Mar 2014 09:35:57 GMT

Yes it is a standard of QlikView

1 is 1 day. Today (05 MAR 2014) is 41 703 (the dates are stored like that in QV)

Today, 12:00 is 41 703,5 (half day = 0,5)

Today, 18:00 is 41 703,75

etc.

1 is 1 day

1 minute is therefore: 1/24/60

15 minutes are therefore : 15/24/60 or 1/24/4 (because 4 times 15 minutes per hour)

Fabrice

Re: How to get processed time?

jagan — Wed, 05 Mar 2014 09:36:59 GMT

Hi,

Try like this

if (Interval(Time#(Time2)-Time#(Time1), 'mm')<=15,

Regards,

Jagan.

Re: How to get processed time?

Wed, 05 Mar 2014 13:38:28 GMT

Ahyel,

Is your question answered ?

Fabrice

Re: How to get processed time?

Wed, 05 Mar 2014 14:01:28 GMT

Hi Fabrice,

Yup Thanks so much for clarifying

Best regards,

Ahyel

Re: How to get processed time?

Wed, 05 Mar 2014 14:04:25 GMT

Hi Jagan,

Thank you so much for this.

Best regards,

Ahyel