Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Top and botton percentiles.

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

1 Solution

Accepted Solutions
sivarajs
Valued Contributor II

Re: Top and botton percentiles.

U can try with fractile funtion

2 Replies
sivarajs
Valued Contributor II

Re: Top and botton percentiles.

U can try with fractile funtion

Not applicable

Re: Top and botton percentiles.

Thanks,

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

EDIT: Works...

Community Browser