Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

thejourneyman
New Contributor

Box plot of a grouped dataset

Hi I have a dataset like this

CountAge

Category

318A
30019A
10020A
5621A
417B
1018B
3519B
2020B
9733C
9434C
8635C
8736C
8737C

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!

7 Replies
krishna_2644
Valued Contributor III

Re: Box plot of a grouped dataset

This way?

1.PNG

thejourneyman
New Contributor

Re: Box plot of a grouped dataset

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.

Employee
Employee

Re: Box plot of a grouped dataset

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:

box.PNG

thejourneyman
New Contributor

Re: Box plot of a grouped dataset

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

Employee
Employee

Re: Box plot of a grouped dataset

Got it. Here is result and settings ..

Age.PNG

ageset.PNG

thejourneyman
New Contributor

Re: Box plot of a grouped dataset

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

kawamuram
Contributor II

Re: Box plot of a grouped dataset

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,

Community Browser