Boxplot and preaggregated data

[Anonymous]

Hi @all,

i need your help.

I like to build a boxplot graph for this dataset (with median, 5/95, min/max):

Name	Rank	Cluster	Count
A	1	T1	100
A	2	T1	5
B	1	T1	50
B	2	T1	100
B	2	T2	15
C	1	T1	20
C	2	T1	25
C	3	T1	20
C	3	T2	25

I am not sure about the right formula for median and 5/95 calculation. Is there a way in qlikview?

Additional Info:

Dimension should be "Name", Boxplot should show the "Rank" Distribution, Cluster is not part of the chart.

Thank you for your help,

Alex