Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
U can try with fractile funtion
U can try with fractile funtion
Thanks,
Seems to be what I was looking for... will test it to see if it does the job.
EDIT: Works...