I have set up 2 List Boxes based on the same dimension to select 1 value each. I then set up another list box, based on the same dimension, which filters the single value from the first 2 List Boxes, thereby giving me 2 values displayed in the 3rd List Box. I now want to do a select all on the 3rd List Box, automatically. Basically, I want the 3rd List Box to have a default setting of Select All so it can interact with Gauge 3.
The idea is to select value 1 from List Box 1 using Dimension 1 and display in Gauge 1. Select value 2 from List Box 2 using Dimension 1 and display in Gauge 2. List Box 3 uses a filter to display value 1 and value 2 in List Box 3 using Dimension 1 and displays the total in Gauge 3.
Hope this makes sense.
Hello,
Sadly for me it not clear want you really expect to get out of it.
Could you please set-up a small sample with 3-5 values or so and describe the expected filter result.
Samples often make it more clear than words, but that's only my personal opinion.
This way we might be able to answer your question, or find a work around with the same result.
Greetings Peter
Peter
Thanks for your reply. Please see attached. I need to have Drop Down List 3 set to Select All.
Regards
Hi there,
Looking at your attached picture, this solution might work.
If you add a parameter to both the DropDownLists, the selected values will be stored in the two parameters.
Simply add a filter to the 3rd DropDownList that uses the both parameters as a filtering value.
This way the 2 selected values of DropDownList 1 and 2 will filter DropDownList 3.
Anyway you van link the DorpDownLists to any other graphics or so.
Greetings and good luck.
Peter
Thanks for your help. I had gone down the road of filtering a Gauge showing the values held in the 2 parameters but having a problem with the syntax. The 2 parameters GaugeDim01 & GaugeDim02 hold the 2 text values:
Regards
hi there,
i would suggest to use the and function and solit the filter in two lines
AND ( (dim01 = variable ) (dim02 = variable) )
if you want an AND function of cource, you can also use OR function if desired. etc.
Greetings
ps i described the formula, if you need it in VA grafics i could provide it to yoy,
Hi there,
The item was about pre-filtering another dropdownList with a previous selected value.
Sadly your request is not possible as far as I know.
Anyway, what would be the use of entering a selection in a "INPUT" box that is ment to be for inputting a unique value of a certain variable.
If you want just want to put your selection on a certain location (visualy) thats different but why would you want to do that.
Please explain the problem you want to solve, surely we will find a way to do it.
Greetings Peter
Hello,
From my understanding, you want to display 'n' values in list control 3..!, which are selected from List control 1 & 2
for example:
You have selected 'X' from List control1 and 'Y' from list control2.
want to show both 'X' and 'Y' In List control3...
Thanks & Regards,
Teja Surapaneni.
Yes Peter, it will.....
Teja Surapaneni.
SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!
See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.
Find more tutorials on the SAS Users YouTube channel.