topic Re: Dependency between drop down list in SAS Visual Analytics

Dependency between drop down list

VenkataBesta — Mon, 19 May 2014 15:08:11 GMT

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.

Re: Dependency between drop down list

MichelleHomes — Mon, 19 May 2014 20:41:02 GMT

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

Re: Dependency between drop down list

VenkataBesta — Tue, 20 May 2014 09:06:40 GMT

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.

Re: Dependency between drop down list

MichelleHomes — Tue, 20 May 2014 13:34:34 GMT

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

Re: Dependency between drop down list

VenkataBesta — Tue, 20 May 2014 14:00:54 GMT

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.

Re: Dependency between drop down list

evanwilson — Thu, 22 Jan 2015 21:07:12 GMT

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 .

Re: Dependency between drop down list

JoshB — Tue, 30 Jun 2015 17:35:03 GMT

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

Re: Dependency between drop down list

SKG — Wed, 09 Dec 2015 08:13:35 GMT

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

Re: Dependency between drop down list

czuchnicki — Thu, 07 Jan 2016 13:56:13 GMT

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

Re: Dependency between drop down list

Joy_SAS — Thu, 07 Jan 2016 15:54:19 GMT

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

Re: Dependency between drop down list

SKG — Sat, 09 Jan 2016 08:10:24 GMT

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

Re: Dependency between drop down list

joshsuihn — Thu, 28 Jan 2016 20:55:28 GMT

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.

Re: Dependency between drop down list

TejaSurapaneni — Fri, 29 Jan 2016 13:20:51 GMT

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#M2767

Let me know.....

Thanks & Regards,

Teja Surapaneni.

Re: Dependency between drop down list

JoshB — Fri, 29 Jan 2016 16:42:19 GMT

I have found it much easier and straight forward to set up interactions for this type of behavior. In my opinion, aesthetically you need to change the "Layout" of the section you are working on to Precision instead of Tiled. It looks much better when you're all said and done. You can then put the drop down lists at the top of the section (not in the section or report prompt area) and link them through an interaction. Alternatively, you can put them in a horizontal container if you want to stick with the Tiled layout.

I've attached a couple screen shots of a quick and dirty example. In this setup, the first drop down filters the values in the second, which in turn filters the plot object. You can even see that VA derives an interaction between the first drop down and the plot itself.

Re: Dependency between drop down list

Explore_SAS — Thu, 04 Feb 2016 16:30:41 GMT

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.

Re: Dependency between drop down list

SomanDavuluri — Fri, 26 Feb 2016 07:00:39 GMT

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

Re: Dependency between drop down list

SKG — Wed, 02 Mar 2016 05:52:22 GMT

Hi Soman,

Sorry for delay

As per above mentioned in my message, i'm going to explain step-by-setp again how to "Dependency between drop down lists in Prompt Section"?

Steps:

1) Create some Parameters whatever you want to dependency between the objects (Drop Down list,...).

For an example

a) "State" and "State" are two data source name -

Right click on data source name "State" and select an option "Create Parameter from Data Item..." and Rename with "State Parameter" 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 Section 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 "State" Drop Down list and select "Add Parameter" and choose "State Parameter".

5) Select Selection list 2(District) and select the Filters tab in the left panel of the report. 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.

Code:-

( State = State Parameter ) OR State Parameter Missing

If you want to do via dag and drop way then follow this steps

a) Select "OR" operator from the Boolean, drag and down on "VISUAL" Tab condition.

b) At first condition select "X=Y" operator from the Comparsion, drag and drop on Top condition.

c) At second condition select "Missing" operator from the Comparison, drag and drop on Bottom condition.

d) Now value specified:

( State = State Parameter ) OR State Parameter Missing

I'm attaching some snapshots in zip file for your reference. Please download this zip file and follow steps and if you'll have any problem then let me know.

Regards,

Sunny Kumar Gupta

Re: Dependency between drop down list

muralavenu_gmail_com — Thu, 03 Mar 2016 04:24:12 GMT

Hi There,

You can't give interactions between TWO Drop Down Lists, if you drop it in (Drop controls here to create a section prompt). That is Global. One Drop Down List or Button Bar will control that Section Charts.You can't see when you try to give interactions in Interaction Tab.

So you need to add\drop the 2 Drop Down lists in center of the section (Drop a report Object here). Now you can see ALL the Controls, Graphs and Tabls, when you try to give interactions in Interaction Tab. It will work as you mapped.

Thanks & Regards,

Venu Murala | Sr. SAS Consultant.

Re: Dependency between drop down list

SKG — Thu, 03 Mar 2016 05:33:57 GMT

Hi Varun,

It's possible to decpendency(or interaction) between two drop down list or more in GLOBAL Prompt. I already mentioned in my last message.

Please let's try once to do it from your end.

Regards,

Sunny Kumar Gupta

Re: Dependency between drop down list

muralavenu_gmail_com — Thu, 03 Mar 2016 15:50:48 GMT

Hi There & Sunny Kumar Gupta,

You can't give (or) see Interactions in Interactions Tab when you try to assign decpendencies (or) interactions between two drop down lists or more in GLOBAL Prompt. If it is local it is possible.

Please watch the short VIDEO for your reference.

Thanks & Regards,
Venu Murala | Sr. SAS Consultant,