Numeric search box

[MVR]

Hello,

I'm quite new with SAS VA, and right now I'm experiencing trouble making a search box with my numeric value. What I want to do is assign a parameter, so if I enter a certain value in the search box it will return that value in both my Geomap and List-table. Is it even possible?

I have my IncidentID variable which is a measure, and I want to assign that to the search box, so the Geomap only returns that certain bubble with the same IncidentID and the List-table does the same. After having looked through both the guide and these forums I haven't really found any explanations for it.

[Madelyn_SAS]

Did you create a filter for your geo map and list table so that IncidentID = IncidentID Parameter? Also, you must press Enter after entering a value in the Text Input Control.

[MVR]

I did not, but I think I found a way around it, but it still gives me some kind of error. As I said I'm not that experienced in SAS VA, and I tried to create a parameter like this:

IF ( IncidentId parameter <> IncidentId_geo )
RETURN IncidentId parameter Missing
ELSE ( IncidentId_geo = IncidentId parameter )

Is this the right way? I get the results I want, but I get a warning as well that says The server did not understand the programs request for data.

[MVR]

Furthermore, I still get an error when I leave my search box blank, and it says: The value has to be a number between 0 and 6833515 (my highest value). What I want when I leave the search box blank is to display all results. So i need the parameter to work as a filter somehow.

[Madelyn_SAS · Accepted solution]

I took the following steps. In my example, the numeric column is Age.

1. Duplicate the Age column and make the duplicate a category (Age Category).
2. Right-click the Age column and create an Age Parameter.
3. On the Text Input Control, add the Age Category in the Category role, and add the Age Parameter in the Parameter role.
4. On the list table, create a filter like this:

                        Age = Age Parameter

You should be able to leave the Text Input Control blank--without errors-- and see all rows. If a value is entered, the table should be filtered by that value.

[MVR]

Thank you so much! It works flawlessly now 🙂