Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

On Demand Webinar: See Why Thousands of QlikView Users Have Switched to Qlik Sense. REGISTER
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Help on Max, Median Percentile


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

14 Replies
Not applicable

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



Not applicable

max(arrival time - departure time)

median(arrival time - departure time)

fractile(arrival time - departure time, .95)

Not applicable

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

Not applicable

Hi Jacob,

yep tried that, it comes out blank

Not applicable

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.

Not applicable

Could I see your data?

Not applicable

DepartmentArrival DateArrival TimeDeparture DateDeparture Time
115/05/201400:13:00:000                  15/05/201402:18:00:000                 
115/05/201400:14:00:000                  15/05/201400:50:00:000                 
115/05/201400:36:00:000                  15/05/201404:30:00:000                 
115/05/201400:44:00:000                  15/05/201402:55:00:000                 
115/05/201401:02:00:000                  15/05/201404:14:00:000                 
115/05/201401:12:00:000                  15/05/201403:10:00:000                 
115/05/201401:26:00:000                  15/05/201403:44:00:000                 
115/05/201401:29:00:000                  15/05/201403:06:00:000                 
115/05/201401:33:00:000                  15/05/201404:38:00:000                 
115/05/201401:52:00:000                  15/05/201402:44:00:000                 
115/05/201402:19:00:000                  15/05/201405:57:00:000                 
115/05/201402:23:00:000                  15/05/201404:00:00:000                 
115/05/201402:47:00:000                  15/05/201404:10:00:000                 
115/05/201402:54:00:000                  15/05/201404:25:00:000                 
Not applicable

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

See the attached file.

Not applicable

Julie, attach sample

22-05-2014 17:04 użytkownik "Julie Teasdale" <qcwebmaster@qlik.com>


Qlik Community <http://community.qlik.com/> Help on Max, Median


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>