1 Reply Latest reply: Jan 13, 2017 10:35 AM by sooa lim RSS

    Displaying Subset of Field as Filter

    sooa lim

      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