Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
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)