10 Replies Latest reply on Jul 25, 2014 7:03 AM by Matt Lutton

    Hide scrollbar in Quick Filter

    Imran Siddiq

      Can I hide the scrollbar in the Quick Filter?

       

      When the quick filter is shrunk to hide the last option... I get the scroll bar.

       

      I have 4 options, but I don't want the user to pick one - this I hide it.

       

      If I remove that option from appearing in the filter, then the data also disappears for it.

       

      Can I:

      a) Hide Scrollbar, or

      b) Hide option from appearing in Filter - but not be missing from the data?

        • 1. Re: Hide scrollbar in Quick Filter
          Matt Lutton

          If you use a parameter (which will be static and single-select only), you can limit the choices to whatever you want, without impacting the actual data.  Are you familiar with parameters?

          • 2. Re: Hide scrollbar in Quick Filter
            Imran Siddiq

            Hi

             

            Giving that a go.

             

            Created a Parameter as a String.

            Have selected to only show the 2 options that I want.

             

            But then how do I connect that to the data?

             

            Thanks again.

            • 3. Re: Hide scrollbar in Quick Filter
              Matt Lutton

              You need to create a calculated field that leverages the parameter--something like:

               

              CASE[ParameterName]

              when "Category" then [Category]

              when "Department" then [Department]

              end

               

              And use that calculation in the view as a Filter

               

              http://downloads.tableausoftware.com/quickstart/feature-guides/parameters.pdf

               

              Every time you create a parameter, there will always need to be a calculation that leverages that.

              1 of 1 people found this helpful
              • 4. Re: Hide scrollbar in Quick Filter
                Imran Siddiq

                That's where I'm struggling.

                 

                The Field is 'Location' *example)

                 

                Location

                East

                West

                Leicestershire

                 

                 

                I only want the user to hit East or West but not see Leicestershire - although Leicestershire should not disappear from the data.

                 

                So the parameter (Select Location)has:

                East

                West

                 

                For the calculated... I get stuck

                 

                CASE [Select Location]

                When "East" Then ??

                When "West" Then ??

                End

                • 5. Re: Hide scrollbar in Quick Filter
                  Joe Oppelt

                  Matthew has you pointed in the right direction.

                   

                  But if you wanted to, you could place a blank container positioned over the last item in the filter.  It's certainly a hack, and it really would only be practical if you wanted to hide the very last item in the list.  And if your data ever changes, your list might change, and ... lots of pitfalls to this.

                   

                  But you could add a blank container to the dashboard.  Float it.  Size it and position it to sit on top of the last filter item.  Format it so that its color is white (otherwise it will be clear and the underlying stuff will show through.)  And I picked white with the assumption that the filter's background is white.  Adjust accordingly if the assumption doesn't hold.

                   

                  So the user will never see the box.  It will mask whatever is underneath it.  It's a hack that works for all sorts of stuff on dashboards.  (And you can only do it on a dashboard.  Not on a stand-alone sheet.)

                  1 of 1 people found this helpful
                  • 6. Re: Hide scrollbar in Quick Filter
                    Matt Lutton

                    I was thinking about swapping dimensions, rather than dimensional values.

                     

                    Would creating a set on the Location field work for you?  Simply choose East and West for your Set and use that as a filter and pill in the view.  This will limit the data in the Set, but the location field will still hold the other values.  I'm not sure exactly what you hope to accomplish--an example workbook would be very helpful in understanding your specific scenario.

                    • 7. Re: Hide scrollbar in Quick Filter
                      Matt Lutton

                      Yeah, you may just want to float a container as Joe has said--if it works, go with it!

                      • 8. Re: Hide scrollbar in Quick Filter
                        Joe Oppelt

                        If you have a parameter and the user selects values...

                         

                            For the calculated... I get stuck

                         

                            CASE [Select Location]

                            When "East" Then ??

                            When "West" Then ??

                            End

                         

                        Can't you set ones and zeros based on what the user selects (or does not select)?  Then place that calc field on the filter shelf, select for 1, and you'll get the records corresponding to the user's choices.

                        • 9. Re: Hide scrollbar in Quick Filter
                          Aaron Clancy

                          You can still use Matt's approach.

                           

                          Just slightly different syntax.

                          Calc:

                          [Parameter] = [Location]

                           

                          Place on filters and set to true

                          This will give you your shorter list defined by the parameter.

                          (No multi-select though, obviously)

                          • 10. Re: Hide scrollbar in Quick Filter
                            Matt Lutton

                            Thank you Aaron--I knew I was having a brain lapse in that moment.

                            1 of 1 people found this helpful