Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
pulin816
New Contributor

Displaying Subset of Field as Filter

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!

CountryContinent
United StatesNorth America
CanadaNorth America
ChinaAsia
JapanAsia
South AfricaAfrica
FranceEurope
1 Solution

Accepted Solutions
pulin816
New Contributor

Re: Displaying Subset of Field as Filter

Solved !

I guess I didn't use the expression properly.

This worked:

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

1 Reply
pulin816
New Contributor

Re: Displaying Subset of Field as Filter

Solved !

I guess I didn't use the expression properly.

This worked:

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