Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
HI,
I need to create a table which calculates the difference between an arrival time and a departure time and then shows the Max, median and 95% in hh:mm:ss
you should use max() and fractile() functions.
regards
Darek
max(arrival time - departure time)
median(arrival time - departure time)
fractile(arrival time - departure time, .95)
Thank you
I've found those. But I need to do the initial calculation first - Difference between arrival and departure time
11:30 - 09:15 = 01:45 for a large number of people and then find teh Max
Hi Jacob,
yep tried that, it comes out blank
I've just changed the time format from hh:mm:ss to DD/MM/YYYY hh:mm:ss and Its not blank anymore, but it is rubbish.
Could I see your data?
Department | Arrival Date | Arrival Time | Departure Date | Departure Time |
1 | 15/05/2014 | 00:13:00:000 | 15/05/2014 | 02:18:00:000 |
1 | 15/05/2014 | 00:14:00:000 | 15/05/2014 | 00:50:00:000 |
1 | 15/05/2014 | 00:36:00:000 | 15/05/2014 | 04:30:00:000 |
1 | 15/05/2014 | 00:44:00:000 | 15/05/2014 | 02:55:00:000 |
1 | 15/05/2014 | 01:02:00:000 | 15/05/2014 | 04:14:00:000 |
1 | 15/05/2014 | 01:12:00:000 | 15/05/2014 | 03:10:00:000 |
1 | 15/05/2014 | 01:26:00:000 | 15/05/2014 | 03:44:00:000 |
1 | 15/05/2014 | 01:29:00:000 | 15/05/2014 | 03:06:00:000 |
1 | 15/05/2014 | 01:33:00:000 | 15/05/2014 | 04:38:00:000 |
1 | 15/05/2014 | 01:52:00:000 | 15/05/2014 | 02:44:00:000 |
1 | 15/05/2014 | 02:19:00:000 | 15/05/2014 | 05:57:00:000 |
1 | 15/05/2014 | 02:23:00:000 | 15/05/2014 | 04:00:00:000 |
1 | 15/05/2014 | 02:47:00:000 | 15/05/2014 | 04:10:00:000 |
1 | 15/05/2014 | 02:54:00:000 | 15/05/2014 | 04:25:00:000 |
Okay, I think I got it. I used subfields and some calculations to find the interval length.
See the attached file.
Julie, attach sample
22-05-2014 17:04 użytkownik "Julie Teasdale" <qcwebmaster@qlik.com>
napisał:
Qlik Community <http://community.qlik.com/> Help on Max, Median
Percentile
reply from Julie Teasdale<http://community.qlik.com/people/craftywytche?et=watches.email.thread>in *Creating
Analytics* - View the full discussion<http://community.qlik.com/message/533911?et=watches.email.thread#533911>