Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
LouisJ
Contributor II
Contributor II

Created a sub-dimension based on grouped data condition from other column, for boxplot

Hello, I am really struggling with this.

I have a dataset with a string column 'Type' and a string column 'Location' :

I would like to create a boxplot for each location (which is easy enough), but I'd like to make a 'sub-dimension' of Location, to have the box-plot only show relevant plots because there's too many locations (in my case the relevancy would be 'count([Type]) >= 10', grouped by location)

Is this possible ? I started qlik recently and am having trouble wrapping my head around the set expressions.

Thanks in advance,

LJ

Labels (3)
1 Reply
LouisJ
Contributor II
Contributor II
Author

This is probably completly wrong, but with my current understanding I've worked out something like this :

= Only(Aggr({<Count(Type)= {'>=10'}>} Location,Location))

(which doesn't work)