05-19-2014 11:08 AM
hi va users,
is there possibility to make dependency between 2 drop down list objects in SAS VA 6.4 ,
for example "Drop Down List1" is taged to country and "Drop Down List2" is taged to States, when we select country then "Drop Down List2" should show respective states for selected country
but generally I feel when we select any value in drop down list as it is a flat table, SAS VA should refresh other drop down list accordingly because it refresh report based on selection.
05-19-2014 04:41 PM
Yes it is possible to have dependencies between drop down lists (or other types of control objects). You simply need to set up a filter interaction between "Drop Down List1" and "Drop Down List2". The default interaction type is "filter" which means the underlying data for "Drop Down List2" is subsetted based on what is selected in "Drop Down List1".
There is a similar example in the documentation using 3 List Control objects and a "brush" type interaction that will demonstrate how this can be achieved by creating an interaction - SAS(R) Visual Analytics 6.4: User's Guide - Creating an Interaction (About 2/3 down the page).
05-20-2014 05:06 AM
Thanks for the answer, it will work only if we have control objects on "Report object" panel, but we cant set interactions at "section prompt" panel, I mean entire section is diveded into 2 panels one is "report object" panel (usuall we drag graphs and list report objects) and other is "section prompt" panel used to drag "drop down list" or other control objects,
05-20-2014 09:34 AM
Thanks for feedback. It seems that you want to have the controls within the section prompt (blue area in your screenshot) - is that correct? If you place your controls within the report area - your red outline area then yes you can set up interactions. A section prompt automatically filters all of the other report objects in the same section, as long as the report object uses the same data source as the section prompt control. Are your controls using the same data source?
05-20-2014 10:00 AM
yes you are true, in red outline area we can setup interactions, but in blue color area (Section Prompt) we cant. yes I am using same data source (Flat Table) , section prompt filters all other objects in red color area but not in blue area.
01-22-2015 04:07 PM
Still seems to be the same in 7.1, which is really annoying. For report and section prompts you should be able to set up interactions between filters. Pretty much ALL my filters are cascading so I am creating them as report objects instead of prompts .
12-09-2015 03:09 AM - edited 12-09-2015 03:13 AM
First of all sorry for delay.
Actually, i also had to face this issue from last long time. But now i've a solution of this problem.
I'm going to explain step-by-step. Please follow it...
1) Create some Parameters whatever you want to dependency between the objects(Drop Down list,...).
For an example "State", "District" -
Right click on data source name "District" and select this option"Create Parameter from Data Item..." and then click on "OK" button.
2) Created parameters are found in the data panel(they are categorized as parameters).
3) Add selection lists into the report prompt area - in this example i'll use 2 diferent categories data objects to simulate a hierarchy. Data objects used are: State, District.
4) Right click on the District and select "Add Parameter" - in this case i'll choose "State Parameter".
5) Select Seletion list 2(District) and select the Filters tab in the left panel. Click on "Add Filters".
6) Define expression for the filter using the "State Parameter " parameter. I use Missing to avoid warning message when no specific State is selected.
Sunny Kumar Gupta
01-07-2016 08:56 AM
Thanks for taking the time to step us through this. However, I'm failing at step 1 as I don't seem to have the 'Create Parameter' optioni on my drop down list. Could you please confirm what version of VA you are using.
02-04-2016 11:30 AM
01-09-2016 03:10 AM
Actually i'm using 7.1 Version SAS VA. But it's avaliable in old version too. Please follow the zip file in my link, each and every steps are mentions there with taken snapshorts.
Let me know if you need any more information from my end. I'm always be there.
Please find the attached file above the post in SKG.
And thanks for asking...
Sunny Kumar Gupta
01-28-2016 03:55 PM
I'd like to see only available items on dropdown list2 depending on dropdownlist1.
In other words, I'd like to see only subset items on dropdownlist2 depending on selected value in dropdownlist1
(Literally, I'd like to create hierarchy. )
Can you please give a right expression in the filter for this case??
01-29-2016 08:19 AM - edited 01-29-2016 08:20 AM
You are talking about Section prompt area right..!!!
If yes.....Refer the below link maybe it was useful to you...
Let me know.....
Thanks & Regards,
02-26-2016 02:00 AM
I have tried doing what u have shown below but i did not find any results in my data, i think there might be some point missing in the explanation below .
Instead of state and district , i have city and location
where if i select city , location has to be mapped .with the respective city .
if not sunnt anyone can help on creating the dependency of filters both placing on section prompt.