Help on Max, Median Percentile

[#1]

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

[#2]

you should use max() and fractile() functions.

regards

Darek

[#3]

max(arrival time - departure time)

median(arrival time - departure time)

fractile(arrival time - departure time, .95)

[#4]

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

[#5]

Hi Jacob,

yep tried that, it comes out blank

[#6]

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.

[#7]

Could I see your data?

[#8]

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

[#9]

Okay, I think I got it. I used subfields and some calculations to find the interval length.

See the attached file.

[#10]

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>