6 Replies Latest reply on Sep 25, 2016 9:38 PM by Surendra Sharma

    Swap/toggle between filters based on another field/parameter value

    . Ashish

      Hello Friends,

       

      I've this requirement where depending on user selection for a particular field, the filter applied on the sheet should change.

       

      for e.g., A user selects "Country" in some parameter or dimension filter, the worksheet get automatically applied with Filter: Country="XXX"

      if the user selects "Year" in the same parameter or dimension filter, the worksheet gets updated with Filter: Year=2016.

       

      I've tried creating this using calculated fields with filter expression and then using them in another calculated field with IF/Case statements. But this is not allowed in Tableau like putting a boolean field inside IF/Case statement.

       

      Can anyone provide any idea for implementing this kind of scenario in general?

       

      Thanks!

      Ashish