topic Re: Dependency and Clearing drop down list in SAS Visual Analytics

Dependency and Clearing drop down list

dstephens22 — Wed, 16 Sep 2015 16:11:59 GMT

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

Re: Dependency and Clearing drop down list

RickStyll_SAS — Fri, 18 Sep 2015 22:47:07 GMT

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

Re: Dependency and Clearing drop down list

dstephens22 — Fri, 18 Sep 2015 19:00:34 GMT

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

Thanks,
Dave

Re: Dependency and Clearing drop down list

dstephens22 — Fri, 19 Feb 2016 13:55:27 GMT

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

Re: Dependency and Clearing drop down list

Explore_SAS — Fri, 19 Feb 2016 15:30:19 GMT

where you have put your dropdowns ? is it at report level or section level ?

Re: Dependency and Clearing drop down list

dstephens22 — Fri, 19 Feb 2016 15:33:38 GMT

Report Level

thanks.

Dave

Re: Dependency and Clearing drop down list

RickStyll_SAS — Fri, 19 Feb 2016 16:36:34 GMT

Hi Dave,

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

Rick

Re: Dependency and Clearing drop down list

dstephens22 — Sat, 20 Feb 2016 02:27:41 GMT

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