Box Plot calculate problem

shahamel — Tue, 13 Nov 2012 09:20:28 GMT

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:

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

topic Box Plot calculate problem in QlikView