0 Replies Latest reply: Nov 13, 2012 4:20 AM by Sandeep Hamelink RSS

    Box Plot calculate problem

    Sandeep Hamelink

      Dear QV-users

       

      I've made a small QV-file in which i wanted to make a boxplot. It worked, but some of the calculated values are wrong:

       

      These are my numbers (BoxTest)

      1, 3, 3, 4, 5, 6, 6, 7, 8, 8

       

      This site:

      http://www.mathsisfun.com/data/quartiles.html

      calculates median, Quartile 1 and Quartile 3

       

      Quartile1 = 3

      Median = 5,5

      Quartile3 = 7

       

      When i made my box plot in Qlikview i got these values:

       

      Quartile1 = 3,5   ->  Fractile (Aggr(BoxTest,[Dim],[BoxTest]), 0.05)

      Median = 5,5      -> Median([BoxTest])

      Quartile3 = 6,5   -> Fractile (Aggr(BoxTest,[Dim],[BoxTest]), 0.05)

       

      Could some help me to found out what the correct expression should be?

       

      PS: I have one dimension called Dim

       

      Thanx in advance