Box plot graph

[jagannalla]

Hello ALL,

I want to learn about Box Plot graph. Please can anyone explain me with breif example.

How to develop it?

[jagannalla]

Any idea please...how to start my work. I understood the algorithm which we need to use to get box plot. But i'm not able to think how to start the work on it.

[jagannalla · Accepted solution]

Hello Friends,

This  Alogrithm which helps you to understand how box plot works.

I could not find any document on this. But I find a way to develop this chart in qlikview. It's very simplle, Load the data as shown in below.

LOAD RowNo() as ID,*,Day(Date) as Day

;

LOAD * INLINE [

    Date, F2

    01-02-2012, 100

    02-02-2012, 3

    03-02-2012, 4  

    01-02-2012, 10

    02-02-2012, 32

    03-02-2012, 45

    01-02-2012, 20

    02-02-2012, 34

    03-02-2012, 46  

    01-02-2012, 101

    02-02-2012, 32

    03-02-2012, 45

];

Steps to create a Box plot graph:

Click On Tools -> Box Plot Wizard -> Next  then

For Dimension, something like date can be used. For aggregator, the value you want the quartiles to measure over. For expression I use the same as the aggregator, not 100% sure what the expression actually does. Display mode - Median I prefer for obvious reasons, I leave the include whiskers box ticked and choose 5/95 percentile as well as tick the use outliers (min/max) Click finish

For your reference i'm attaching sample file.