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

LouisJ — Wed, 06 Jul 2022 08:15:53 GMT

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,

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

LouisJ — Wed, 06 Jul 2022 08:29:34 GMT

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)

topic Re: Created a sub-dimension based on grouped data condition from other column, for boxplot in QlikView

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

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