Box plot of a grouped dataset - Qlik Community

Anonymous · ‎2018-04-24

Hi I have a dataset like this

Count	Age	Category
3	18	A
300	19	A
100	20	A
56	21	A
4	17	B
10	18	B
35	19	B
20	20	B
97	33	C
94	34	C
86	35	C
87	36	C
87	37	C

I want to plot the age distribution of each category which seems natural enough and in a boxplot format however its seems difficult to make it display what I want. Please help thanks!

Qrishna · ‎2018-04-25

This way?

Anonymous · ‎2018-04-25

I was thinking more of a box and whisker plot where each plot is a category showing the median max and min age for that category.

Lisa_P · ‎2018-04-25

Hi Bob,

I took your data into Qlik Sense and simply created a box plot to show the count distribution using the standard settings with your two dimensions and it came out like this:

Anonymous · ‎2018-04-25

It should be more of a distribution of the age itself and not the distribution of the counts. So A has median first third quartile of 19. B has median 19 first quartile 18.xx third quartile 20. C has median of 35 first quartile 33.xx third quartile 36.xx

Lisa_P · ‎2018-04-26

Got it. Here is result and settings ..

Anonymous · ‎2018-04-27

Thanks! It's a little .. Odd? Cat C has a max age of 37 but the max age shown in the graph is 70+?

Anonymous · ‎2018-04-27

Hi,

I guess the problem is that you first dimension should be age and the expression should be sum(count).

https://help.qlik.com/en-US/sense/September2017/Subsystems/Hub/Content/Visualizations/BoxPlot/box-pl...

Regards,

Count	Age	Category
3	18	A
300	19	A
100	20	A
56	21	A
4	17	B
10	18	B
35	19	B
20	20	B
97	33	C
94	34	C
86	35	C
87	36	C
87	37	C

Count	Age	Category
3	18	A
300	19	A
100	20	A
56	21	A
4	17	B
10	18	B
35	19	B
20	20	B
97	33	C
94	34	C
86	35	C
87	36	C
87	37	C

Count	Age	Category
3	18	A
300	19	A
100	20	A
56	21	A
4	17	B
10	18	B
35	19	B
20	20	B
97	33	C
94	34	C
86	35	C
87	36	C
87	37	C