June 2013
Beginner to intermediate
290 pages
4h 59m
English
Box plot charts, or box and whisker charts, are often used for displaying statistical mean and quartile information.
This can be useful for seeing how a value ranges across categories by visualizing the median, the twenty-fifth and seventy-fifth percentile, and the outlying values.
With a simple data set, it is easier to create the chart manually than using the wizard that QlikView provides—although there is a slightly strange sequence of actions to go through a "funny"—that you need to know about.
Load the following script:
LOAD * INLINE [
Country, Value
USA, 12
USA, 14.5
USA, 6.6
USA, 4.5
USA, 7.8
USA, 9.4
UK, 11.3
UK, 10.1
UK, 3.2
UK, 5.6
UK, 3.9
UK, 6.9
];There is a "funny" ...