2 Replies Latest reply on Dec 18, 2013 11:06 AM by NACSA Tableau

    Search to contain one word within full name

    NACSA Tableau

      Hi everyone,


      I have a list of clients by state and created a parameter to search by client name or state. However, the search only comes up when the client's full name is typed in. Is there a way to have the searches come up when parts of the name matches the full name?


      The current formula that I'm using is:


      IF [State] = [Filter On] AND [Client Name] != [Filter On] THEN "Show"

      ELSEIF [Client Name] = [Filter On] AND [State] != [Filter On] THEN "Show"

      ELSE "Hide" END


      Thank you!