topic Re: calculation duration time in QlikView

calculation duration time

momofiore — Wed, 25 Nov 2020 16:16:04 GMT

Hey guys

i m trying to calculate the time spent by each (organisation) for each (ticket) using (activityDateTime) in this data and store this duration in an other label. somebody helps me please to write a script to do this. thanks guys. here u can find data with .xlsx extension

NOTE: please note that same (ticket) goes from an (organisation) to an other many times.

here u can find 2 examples of (ticket) with 2 (organisation)

Re: calculation duration time

agomes1971 — Mon, 11 Jun 2018 14:06:15 GMT

Hi,

please see this...

Calculating time diff in Qlikview

HTH

André Gomes

Re: calculation duration time

Chanty4u — Mon, 11 Jun 2018 14:07:11 GMT

what is the logic to caluclate the duration?

opendate-resolveddate? and what is activitydatetime?

Re: calculation duration time

shiveshsingh — Mon, 11 Jun 2018 14:08:33 GMT

Do you need difference of two columns here? how are you calculating the time spent?

Re: calculation duration time

YoussefBelloum — Mon, 11 Jun 2018 14:13:43 GMT

Hi,

try this for time spent by ticket and by organisation (in minutes for example):

Re: calculation duration time

momofiore — Mon, 11 Jun 2018 15:27:39 GMT

hey.

no . i de like to calculate total time on minut that each organisation spent on each ticket using (activitydatetime).

for example (organisation) NORD spent 1 days 2 h in (ticket) ER:1324309.

how do i calculate this. i based my calculation on row of (activitydatetime)

-->for ER:1324309:

1) first activity was on 01/05/2018 07:39:45 ,this activity made by (organisation) SUD

2) second activity was on 01/05/2018 07:41:01 ,this activity made by (organisation) SUD

3) spent time is (01/05/2018 07:41:01)-(01/05/2018 07:39:45)=0 day 0 h 1 min 16 sec

-->then i calculate the time for organisation (NORD)

ultimatly i will store the time spent by each (organisation).

for example

-->for ticket ER:1324309:

SUD spent 0 day 1 h 5 min 16 sec

NORD spent 0 day 1 h 7 min 13 sec

hope i explained more. thanks

Re: calculation duration time

momofiore — Mon, 11 Jun 2018 15:44:09 GMT

hey @youssefbelloum. you are to close. i found some mistake in ur calculation. because the ticket goes from organisation to an other. u should take this in consideration.

no . i de like to calculate total time on minut that each organisation spent on each ticket using (activitydatetime).

for example (organisation) NORD spent 1 days 2 h in (ticket) ER:1324309.

how do i calculate this. i based my calculation on row of (activitydatetime)

-->for ER:1324309:

1) first activity was on 01/05/2018 07:39:45 ,this activity made by (organisation) SUD

2) second activity was on 01/05/2018 07:41:01 ,this activity made by (organisation) SUD

3) spent time is (01/05/2018 07:41:01)-(01/05/2018 07:39:45)=0 day 0 h 1 min 16 sec

-->then i calculate the time for organisation (NORD)

ultimatly i will store the time spent by each (organisation).

for example

-->for ticket ER:1324309:

SUD spent 0 day 1 h 5 min 16 sec

NORD spent 0 day 1 h 7 min 13 sec

hope i explained more. thanks

Re: calculation duration time

momofiore — Mon, 11 Jun 2018 15:45:21 GMT

hey.

no . i de like to calculate total time on minut that each organisation spent on each ticket using (activitydatetime).

for example (organisation) NORD spent 1 days 2 h in (ticket) ER:1324309.

how do i calculate this. i based my calculation on row of (activitydatetime)

-->for ER:1324309:

1) first activity was on 01/05/2018 07:39:45 ,this activity made by (organisation) SUD

2) second activity was on 01/05/2018 07:41:01 ,this activity made by (organisation) SUD

3) spent time is (01/05/2018 07:41:01)-(01/05/2018 07:39:45)=0 day 0 h 1 min 16 sec

-->then i calculate the time for organisation (NORD)

ultimatly i will store the time spent by each (organisation).

for example

-->for ticket ER:1324309:

SUD spent 0 day 1 h 5 min 16 sec

NORD spent 0 day 1 h 7 min 13 sec

hope i explained more. thanks

Re: calculation duration time

momofiore — Tue, 12 Jun 2018 10:28:10 GMT

Hey youssefbelloum i added a field that can help now.

(Activity) made by organization:

--> INITIALISATION: which (organization) started the (ticket)

-->TRANSFER TO : an (organization) send the ticket to an other organization

-->STATE CHANGEMENT: an oragnization made a chagement

-->SOLUTION: an (organization) close the ticket

please if somebody try to help me. ide like to know how long was the ticket in NORD as in SUD

Ticket	OpenDate	ResolveDate	Activity	ActivityDateTime	Organization
ER:1299694	22/03/2018	23/03/2018	INITIALISATION	22/03/2018 13:19:07	NORD
ER:1299694	22/03/2018	23/03/2018	TRANSFER TO	22/03/2018 13:52:55	NORD
ER:1299694	22/03/2018	23/03/2018	STATE CHANGEMENT	22/03/2018 13:53:03	NORD
ER:1299694	22/03/2018	23/03/2018	TRANSFER TO	22/03/2018 14:13:12	SUD
ER:1299694	22/03/2018	23/03/2018	STATE CHANGEMENT	22/03/2018 14:13:19	SUD
ER:1299694	22/03/2018	23/03/2018	TRANSFER TO	22/03/2018 14:30:35	SUD
ER:1299694	22/03/2018	23/03/2018	STATE CHANGEMENT	22/03/2018 14:31:43	SUD
ER:1299694	22/03/2018	23/03/2018	STATE CHANGEMENT	22/03/2018 14:31:47	SUD
ER:1299694	22/03/2018	23/03/2018	STATE CHANGEMENT	22/03/2018 14:46:44	NORD
ER:1299694	22/03/2018	23/03/2018	TRANSFER TO	22/03/2018 14:46:44	NORD
ER:1299694	22/03/2018	23/03/2018	SOLUTION	23/03/2018 09:35:26	SUD
ER:1299694	22/03/2018	23/03/2018	TRANSFER TO	23/03/2018 09:35:47	SUD
ER:1287929	03/03/2018	05/03/2018	INITIALISATION	03/03/2018 16:28:07	NORD
ER:1287929	03/03/2018	05/03/2018	STATE CHANGEMENT	03/03/2018 16:37:18	NORD
ER:1287929	03/03/2018	05/03/2018	TRANSFER TO	03/03/2018 16:37:18	NORD
ER:1287929	03/03/2018	05/03/2018	TRANSFER TO	05/03/2018 07:55:23	SUD
ER:1287929	03/03/2018	05/03/2018	TRANSFER TO	05/03/2018 08:32:01	NORD
ER:1287929	03/03/2018	05/03/2018	SOLUTION	05/03/2018 14:32:23	NORD
ER:1287929	03/03/2018	05/03/2018	TRANSFER TO	05/03/2018 14:32:59	NORD