Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Become an analytics expert with Qlik's new 15 week course: Applied Data Analytics using Qlik Sense. READ MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
amiroh81
Creator
Creator

Calculate time gap

Hello everyone

I have the following data:

    

userFirst attamptFirst SuccssesDelta (Min)
A15/04/2018 09:13:1815/04/2018 10:10:3957
B15/04/2018 09:10:2615/04/2018 09:23:2113
C15/04/2018 12:26:0815/04/2018 12:30:054

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

1 Solution

Accepted Solutions
marcus_sommer
MVP & Luminary
MVP & Luminary

I think you need something like this:

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

- Marcus

View solution in original post

2 Replies
YoussefBelloum
Champion
Champion

Hi,

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

marcus_sommer
MVP & Luminary
MVP & Luminary

I think you need something like this:

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

- Marcus

View solution in original post