1 Reply Latest reply on Sep 13, 2016 12:58 PM by diego.medrano

    Advanced nested filtering using parameters

    Alda Pontes

      Hello dear friends!


      Our company has an industry taxonomy that is a bit confusing, this is how it is diagrammed:


      Sector > Industry > Sub-industry


      Goal of this post: for me to learn how to make a three level, nested filtering taxonomy "smart". Meaning, when I pick an industry within a sector, I only want the subindustry filter to show the subindustries within the industry that was picked.


      We have 16 top level sectors, but not every sector has a sub-industry, about half of them do.


      When putting together the filtering above, I made the industry filters "smart" so that the only choices available are those under the sector that the user toggled (Under Choose sector, which is a parameter)


      I defined choose sector industries as:

      if [Choose sector] = [Sector] then [Industry] else null end


      --> this allows only industries within the toggled sector to show up.


      I defined choose sector subindustries (ideally the name would be choose subindustries) as:

      if [Choose sector] = [Sector] then [Subindustry] else null end


      Since "Choose sector industries" is not a parameter, I cannot use the same approach as I did for the sector <> industry relationship.


      Does anyone have any idea how I can manage to do this?