Displaying Subset of Field as Filter

[Anonymous]

Hi Everyone,

I have a question about displaying subsets of a Given filed depending on a condition as show them in a Filter Pane. (Qlik Sense)

I have two Fields Country and Continent, and on my filter pane I would only like to show Countries in North America.

I tried Aggr([Continent]='North America', Country)  for my filter pane dimension,

but it seems Aggr can't be used as a valid expression for Dimensions.

Does anybody no how to solve this?

Thank you!

Country	Continent
United States	North America
Canada	North America
China	Asia
Japan	Asia
South Africa	Africa
France	Europe

[Anonymous · Accepted solution]

Solved !

I guess I didn't use the expression properly.

This worked:

=Aggr(Only({1<[Continent]={'North America'}>}[Country]), [Country])