Exploring, modeling, predicting and reporting with SAS Visual Analytics and SAS Visual Statistics

Dependency between drop down list

Reply
New Contributor
Posts: 3

Dependency between drop down list

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.

Thanks,

Venkat.

Super User
Posts: 1,208

Re: Dependency between drop down list

Hi Venkat,

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).

Kind Regards,

Michelle

New Contributor
Posts: 3

Re: Dependency between drop down list

Hi Michelle,

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,

Thanks,

Venkat.

Attachment
Super User
Posts: 1,208

Re: Dependency between drop down list

Hi Venkat,

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?

Kind Regards,

Michelle

New Contributor
Posts: 3

Re: Dependency between drop down list

Hi Michelle,

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.

Thanks,

Venkat.

New Contributor
Posts: 4

Re: Dependency between drop down list

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 Smiley Sad.

Contributor
Posts: 55

Re: Dependency between drop down list

Has there been any update on this feature? The ability to have interactions between section prompts would really improve VA.

Contributor SKG
Contributor
Posts: 47

Re: Dependency between drop down list

[ Edited ]

Hi Everyone,

 

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.

 

Regards,

Sunny Kumar Gupta

Attachment
Attachment
Attachment
Attachment
Attachment
New Contributor
Posts: 3

Re: Dependency between drop down list

Hi there,

 

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.

 

Many thanks,

Cammie

 

SAS Employee
Posts: 60

Re: Dependency between drop down list

Hi Cammie,

 

Parameters were added as a new feature in both SAS Visual Analytics Designer and SAS Visual Analytics Viewer in the 7.1 release.

 

Regards,

Joy

 

 

Contributor
Posts: 69

Re: Dependency between drop down list

to create filters using dropdowns, i would suggest add a horizontal container and then add your dropdowns to that container and then add interaction in between them to filter from one to another.
Contributor SKG
Contributor
Posts: 47

Re: Dependency between drop down list

Hi Cammie,

 

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...

 

Regards,

Sunny Kumar Gupta

New Contributor
Posts: 4

Re: Dependency between drop down list

Hi!

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?? 

 

Thank you.

Regular Contributor
Posts: 196

Re: Dependency between drop down list

[ Edited ]

Hello Joshsuihn,

 

You are talking about Section prompt area right..!!!

 

If yes.....Refer the below link maybe it was useful to you...

 

 

https://communities.sas.com/t5/SAS-Visual-Analytics/How-to-filter-a-filter-in-SAS-VA/m-p/234544#M276...

 

 

 Let me know.....

 

Thanks & Regards,

Teja Surapaneni.

 

 

Contributor
Posts: 41

Re: Dependency between drop down list

HI SUnny

 

 

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.

 

 

regards

 

Post a Question
Discussion Stats
  • 23 replies
  • 3393 views
  • 1 like
  • 13 in conversation