2 Replies Latest reply: Sep 24, 2012 5:17 AM by roope_ne RSS

    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