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.
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.
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.
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.
ps i described the formula, if you need it in VA grafics i could provide it to yoy,
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.
From my understanding, you want to display 'n' values in list control 3..!, which are selected from List control 1 & 2
You have selected 'X' from List control1 and 'Y' from list control2.
want to show both 'X' and 'Y' In List control3...
Thanks & Regards,
Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.
If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website.
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.