topic Re: How to use drop-down lists for parameter filtering in SAS Visual Analytics in SAS Visual Analytics

How to use drop-down lists for parameter filtering in SAS Visual Analytics

Janet5 — Thu, 12 Apr 2018 16:56:21 GMT

Does anyone know of how to add a search field in a drop down list in SAS VA? I have a few hundred items for a drop down list and would like for the user to do a search rather than scroll through all if they know exact item. If not, they have the option to scroll through to select what they would like to see. Any help is much appreciated!

Re: How to use drop-down lists for parameter filtering in SAS Visual Analytics

FredrikE — Fri, 13 Apr 2018 10:17:00 GMT

Hi!

What you can do is to add a text-input box and assign a parameter to that box.

Then add a filter to your drop down that uses that parameter to filter out values.

In the filter you can use "upcase(var) contains upcase(parm)" to make it possible to search for parts of the value regardless of case.

Hope this helps 🙂

//Fredrik

Re: How to use drop-down lists for parameter filtering in SAS Visual Analytics

Janet5 — Fri, 13 Apr 2018 14:07:46 GMT

Thanks! I'll try that out!