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
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.
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
