Box plot graph

jagannalla — Thu, 07 Jun 2012 15:45:35 GMT

Hello ALL,

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

How to develop it?

Box plot graph

jagannalla — Thu, 07 Jun 2012 17:43:41 GMT

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.

Re: Box plot graph

jagannalla — Thu, 07 Jun 2012 18:52:19 GMT

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.

topic Box plot graph in QlikView

Box plot graph

Box plot graph

Re: Box plot graph