Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikView forum consolidation is complete. Labels are now required. LEARN ABOUT LABELS
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Help on Max, Median Percentile

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

14 Replies
Not applicable

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

regards

Darek

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>

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>