topic Re: Multple text entries to filter in SAS Visual Analytics

Multple text entries to filter

LisaSAS — Thu, 20 Oct 2016 21:20:56 GMT

I'm very new to SAS Va, so bear with me if this is an easy one.

I have a text field where the user can enter in a value which in turn my report filters based on that. I want the ability to be able to enter multple values in a text box - is this possible? My list is too large to do in any other type of control, that's why I initially chose the text input.

Re: Multple text entries to filter

Madelyn_SAS — Mon, 24 Oct 2016 20:17:11 GMT

The text input control supports only one value. You could use the text input control with a parameter to filter, for example, the contents of a list control.

Re: Multple text entries to filter

LisaSAS — Mon, 24 Oct 2016 20:40:28 GMT

If I'm understanding you correctly, this would be a two step process for the user, correct? First the user would enter in the text input, then they would select from the list control? I'm trying to make this as seamless for the user. Right now I have a List Control within a Prompt container - this works, I can select multiple items, however, because of the size of my list, it's not very user-friendly. It would be nice to be able to start typing, LI for example and then it goes to my list that all start with LI and as I type my list gets shorter. That's why I was looking at the text input, if only I could enter multple items. I'm wondering if there's a way that I have it as a training until SAS has this feature available, but what if I have a text input field, and then have the user separate out by commas....In VA can I then parse out the field? Would I then be able to use that to drill down my crosstab?

Re: Multple text entries to filter

SASKiwi — Tue, 25 Oct 2016 23:19:27 GMT

One option worth exploring might be two drop down lists, the first less granular one filtering the second as discussed in this post:

https://communities.sas.com/t5/SAS-Visual-Analytics/How-to-filter-a-filter-in-SAS-VA/m-p/230692#M2687