Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 |
Solved !
I guess I didn't use the expression properly.
This worked:
=Aggr(Only({1<[Continent]={'North America'}>}[Country]), [Country])
Solved !
I guess I didn't use the expression properly.
This worked:
=Aggr(Only({1<[Continent]={'North America'}>}[Country]), [Country])