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

Dependency and Clearing drop down list

Reply
Contributor
Posts: 24

Dependency and Clearing drop down list

Hi:

 

I created 3 drop downs in my report that are dependent on each other through parameters.  The variables are Region, District, and Territory.

 

So if Region is picked it only shows the Districts for that Region.  Then I pick a district and it only shows me the territoires for that district.

 

 Works great : except, if I pick a region, then a district, then a territory and i "clear" the region it retains the value of district  and territory even though it is not showing. So if i move to the next section the values are off but it doesn' tell me its that district or territory only.

 

So My quesiton:  is there a way to have it clear the selection of district and territory when I "clear" Region?  At the moment i have to clear each independently which is confusing to other users.

 

thanks in advance.

 

Dave

SAS Employee
Posts: 44

Re: Dependency and Clearing drop down list

[ Edited ]

Dave,

 

Are you associating parameters with drop-down lists in the body of a section so that you can filter across sections and use interactions between the drop-down list (cascading prompts)? If so, you can create an advanced data source filter (global) from the left panel that includes nested IF ELSE RETURN logic to test if the region parameter is missing. If not missing, filter the region data item by the region parameter value and then test if the district parameter is missing in a nested IF ELSE RETURN, and so on. If the region parameter is missing, then return 1 = 1 in the advanced filter expression, so that no regions, districts, or territories are filtered for any section.

 

SAS is planning to include cascading filter prompts at the report and section level in a future release so you wouldn't have to do this.

 

Dave, I hope that make sense and helps.

 

Rick Styll

Contributor
Posts: 24

Re: Dependency and Clearing drop down list

I'll take a look. It gives me a direction to go in.

Thanks,
Dave
Contributor
Posts: 24

Re: Dependency and Clearing drop down list

Hi Rick:

 

It's been awhile since this post.  I have tried many times to get something like this to work but i am afraid i may be on the wrong track.

 

Do you have or know where I can find any examples of what you proposed?  

 

I have three variables: region, district, and territory.  They cascade fine (using parameters), but i can't seem to get them to clear.

 

Thanks for any help you can give.

 

Dave

 

Contributor
Posts: 69

Re: Dependency and Clearing drop down list

where you have put your dropdowns ? is it at report level or section level ?
Contributor
Posts: 24

Re: Dependency and Clearing drop down list

Report Level

 

thanks.

Dave

SAS Employee
Posts: 44

Re: Dependency and Clearing drop down list

Hi Dave,

 

So when you try to clear region, it's not clearing district and territory, for example?

 

Rick

Contributor
Posts: 24

Re: Dependency and Clearing drop down list

Correct.  It doesn't clear the district or territory.  You have to clear each one at a time (first territory, then district, then region).  Easy enough to me, but it annoys my users. Smiley Sad

 

 

 

Ask a Question
Discussion stats
  • 7 replies
  • 878 views
  • 2 likes
  • 3 in conversation