-
1. Re: Wildcard Match
David Li Nov 22, 2016 8:52 AM (in response to Matthew Hefferon)1 of 1 people found this helpfulHi Matthew! What you can do is create an integer parameter that allows people to search. For instance, let's say your parameter is called [Search]. Then, you would create this calculated field for filtering:
[Search] = [Store #]
Filter in the true values.
EDIT: I completely misunderstood how this worked at first. Different solution posted.
-
2. Re: Wildcard Match
Matthew Hefferon Nov 22, 2016 9:58 AM (in response to David Li)Hey David!
Your solution gave me the ability to search store numbers without quotes. Awesome! The issue is when the workbook opens it just shows a single store number which is coming from field "current value" in the search parameter. By default I need to show all store numbers when opening. Also if I search a single store then delete my search criteria I need all stores to show back up.
Thanks
-
3. Re: Wildcard Match
David Li Nov 22, 2016 10:37 AM (in response to Matthew Hefferon)Oh, gotcha! Change the formula to this:
[Search] = [Store #] OR [Search] = ""
This will show all values when [Search] is blank.
Also, you'll want to change Allowable Values to "All" and make sure that the Search parameter is blank when you save or publish the workbook.
-
4. Re: Wildcard Match
Matthew Hefferon Nov 22, 2016 12:18 PM (in response to David Li)Thanks David!
-
5. Re: Wildcard Match
David Li Nov 22, 2016 12:29 PM (in response to Matthew Hefferon)You're welcome!