3 Replies Latest reply on May 2, 2016 2:56 AM by Tableau kumar

    Use dimension as dynamic filter.

    saravana.komathinathan

      How to use dimension as dynamic filter in worksheet using parameter control?

        • 1. Re: Use dimension as dynamic filter.
          Andrew Watson

          Parameters aren't dynamic. You can make a filter dynamic using the 'Only relevant values' setting of the filter.

          • 2. Re: Use dimension as dynamic filter.
            saravana.komathinathan

            Hi Andrew,

            I tried with Case statement. It worked. Thanks.

            • 3. Re: Use dimension as dynamic filter.
              Tableau kumar

              Dynamically Selecting Measure & Dimension values in the View.

               

              Parameter: Parameters are variable, which are used to pass the values dynamically to the view.

               

              An example of using Parameter is "Dynamically Selecting Measure & Dimension values in the View.

               

               

              1) Create a Parameter for Dimension Selection purpose "Dimension Parameter", By using this Parameter, we can select the Dimension Value (Field) dynamically.

               

              9.png

              2) Create a Parameter for Measure Selection purpose "Measure Parameter", By using this Parameter, we can select the Measure Value (Field) dynamically.

              10.png

              3) Create a Calculated Field for Dimension Selection  using the syntax in the image.

              1`4.png

              4) Create another calculated field for Measure Selection like below image.

              15.png

              3) Place "Measure Selection", "Dimension Selection"  calculated fields, Right click on both Parameters & Click on "Show Parameter Control". (Note: We can  select Max 1 Value at a time from any parameter, It means Parameter limitation is Select Max 1 Value at a time.)

              11.png

              12.png

               

              13.png

               

              ==============================
              The following example explains when measures located on two databases.

               

              Create a Parameter5.png

               

              By using Parameter, create 2 Calculation for QS1, QS26.png

              7.png

              Then Place two measures on the Report like below image.Then you can define different marks for both measures.

              121.png

              When we select "QS1" from parameter,

              122.png

              When select "QS2",

              1123.png

              When Select "Both",

              121.png