Is it possible to create box plots in qvw?

[#1]

Hi,

Is it possible to create box plots in qvw? please see attached need graph exactly that looks in attached.

Thanks.

[sunny_talwar]

Yes you can. Have you looked at the Box Plot Wizard within Tools?

[marcus_sommer]

Have a look here: Recipe for a Box Plot

- Marcus

[#4]

Thanks. first time I am using this box plot. I have followed below showing Marcus example. once completed my chart is showing 'no data to display'. how can I use this box plot? please suggest me

[#5]

Thanks. I tried this but chart is showing 'no data to display'. please suggest me how to use the box plot?

[#6]

here is the dimension

=ValueList('Open','Closed','Required','Proposed','Cancelled') that I have to use

[sunny_talwar]

Can you share the data you are working with?

[marcus_sommer]

If you used valuelist as calculated dimension you need to apply these valueslist in each expression, too. This could be quite complicated and won't work in each case. Better would be you used "normal" fields as dimension - maybe you need then some adjustment on your datamodel.

- Marcus

[#9]

below are the ones I used

Dimension: ValueList('Open','Closed','Required','Proposed','Cancelled'),

Expressions:

for Box Plot Top I used this:

Pick(Match(ValueList('Open','Closed','Required','Proposed','Cancelled'),
'Open','Closed','Required','Proposed','Cancelled'),
Fractile(TOTAL [Open], 0.75),
Fractile(TOTAL [Closed], 0.75),
Fractile(TOTAL [Required], 0.75),
Fractile(TOTAL [Proposed], 0.75),
Fractile(TOTAL [Cancelled], 0.75))

for Box Plot Bottom I used this:

Pick(Match(ValueList('Open','Closed','Required','Proposed','Cancelled'),
'Open','Closed','Required','Proposed','Cancelled'),
Fractile(TOTAL [Open], 0.25),
Fractile(TOTAL [Closed], 0.25),
Fractile(TOTAL [Required], 0.25),
Fractile(TOTAL [Proposed], 0.25),
Fractile(TOTAL [Cancelled], 0.25))

for Box Plot Middle I used this:

Pick(Match(ValueList('Open','Closed','Required','Proposed','Cancelled'),
'Open','Closed','Required','Proposed','Cancelled'),
MEDIAN([Open]),
MEDIAN([Closed]),
MEDIAN( [Required]),
MEDIAN( [Proposed]),
MEDIAN([Cancelled]))

for Box Plot Lower Whisker I used this:

Min(If(ValueList('Open','Closed','Required','Proposed','Cancelled')>= Aggr(2.5*Fractile(total <ValueList('Open','Closed','Required','Proposed','Cancelled')> ValueList('Open','Closed','Required','Proposed','Cancelled'),0.25)
-1.5*Fractile(total <ValueList('Open','Closed','Required','Proposed','Cancelled')> ValueList('Open','Closed','Required','Proposed','Cancelled'),0.75),
ValueList('Open','Closed','Required','Proposed','Cancelled'), ValueList('Open','Closed','Required','Proposed','Cancelled')), ValueList('Open','Closed','Required','Proposed','Cancelled')))

for Box Plot Upper Whisker I used this:

Min(If(ValueList('Open','Closed','Required','Proposed','Cancelled')>= Aggr(2.5*Fractile(total <ValueList('Open','Closed','Required','Proposed','Cancelled')> ValueList('Open','Closed','Required','Proposed','Cancelled'),0.75)
-1.5*Fractile(total <ValueList('Open','Closed','Required','Proposed','Cancelled')> ValueList('Open','Closed','Required','Proposed','Cancelled'),0.25),
ValueList('Open','Closed','Required','Proposed','Cancelled'), ValueList('Open','Closed','Required','Proposed','Cancelled')), ValueList('Open','Closed','Required','Proposed','Cancelled')))

for Lower Outlier I used this:

Min(If(ValueList('Open','Closed','Required','Proposed','Cancelled')< Aggr(2.5*Fractile(total <ValueList('Open','Closed','Required','Proposed','Cancelled')> ValueList('Open','Closed','Required','Proposed','Cancelled'),0.25) -1.5*Fractile(total <ValueList('Open','Closed','Required','Proposed','Cancelled')>
ValueList('Open','Closed','Required','Proposed','Cancelled'),0.75), ValueList('Open','Closed','Required','Proposed','Cancelled'),
ValueList('Open','Closed','Required','Proposed','Cancelled')), ValueList('Open','Closed','Required','Proposed','Cancelled')))

for Upper Outlier I used this:

Min(If(ValueList('Open','Closed','Required','Proposed','Cancelled')< Aggr(2.5*Fractile(total <ValueList('Open','Closed','Required','Proposed','Cancelled')> ValueList('Open','Closed','Required','Proposed','Cancelled'),0.75) -1.5*Fractile(total <ValueList('Open','Closed','Required','Proposed','Cancelled')>
ValueList('Open','Closed','Required','Proposed','Cancelled'),0.25), ValueList('Open','Closed','Required','Proposed','Cancelled'),
ValueList('Open','Closed','Required','Proposed','Cancelled')), ValueList('Open','Closed','Required','Proposed','Cancelled')))