Discussion Board for collaboration on QlikView Layout & Visualizations.
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.
Go to Solution.
U can try with fractile funtion
Seems to be what I was looking for... will test it to see if it does the job.