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
