Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

shahamel
Contributor

Box Plot calculate problem

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

Community Browser