Calculate time gap

amiroh81 — Tue, 17 Apr 2018 07:58:53 GMT

Hello everyone

I have the following data:

user	First attampt	First Succsses	Delta (Min)
A	15/04/2018 09:13:18	15/04/2018 10:10:39	57
B	15/04/2018 09:10:26	15/04/2018 09:23:21	13
C	15/04/2018 12:26:08	15/04/2018 12:30:05	4

When I show the time that went from experience to success for a single user that is displayed correctly, I can not show the average time from the first attempt to the success for all users.

The problem is that First attampt and First Succsses is a measure that I am calculating:

First attampt - min(min_try_c)

First Succsses - min(min_seccuss_c)

Can anyone help?

Thanks in advanced

Amir

Re: Calculate time gap

YoussefBelloum — Tue, 17 Apr 2018 08:30:04 GMT

Hi,

would you be able to attach sample data/sample app ?

Re: Calculate time gap

marcus_sommer — Tue, 17 Apr 2018 10:26:14 GMT

I think you need something like this:

interval(avg(aggr(min(min_seccuss_c) - min(min_try_c), user)), 'm')

- Marcus

topic Calculate time gap in QlikView

Calculate time gap

Re: Calculate time gap

Re: Calculate time gap