Top and botton percentiles.

[#1]

Hi, i'm making a QV app that does performance metrics.

It has fields e.g. [starttime(datetime)][user][host][task][duration(s)].
I would like to get the top 10% and the bottom 10% of duration. (fastest and slowest)

Any ideas how I could do this in Qlikview. I've used range before but I can't think of a way to use it for this.

Hint's, ideas what QV functions I could study or any example would be appreciated.

-roope_ne

[sivarajs · Accepted solution]

U can try with fractile funtion

[#3]

Thanks,

Seems to be what I was looking for... will test it to see if it does the job.

EDIT: Works...