topic Re: Filtered filters in SAS Visual Analytics

Filtered filters

mattneo — Mon, 15 Jun 2020 14:12:43 GMT

Hi,

I have the following filters at Page Level:

1) Dropdown list #1 for Source with categories( Mailbox A, Feedback Form A, App A)

2) Dropdown list #2 for Medium with categories( Email, Web Portal, Agency App, Phone, Counter)

So the above 2 will dictate other objects in the page, like charts, crosstab etc.....Here's the qn: When I choose Mailbox A at the Dropdown list#1, how can Dropdown list#2 automatically select Email? I can add an Advanced Filter in Dropdown List #2 (using IF..ELSE) to show only Email when Mailbox A is selected at #1, but showing doesn't mean selecting. How to get Email to be selected without users doing so? I am using SAS VA 8.3.

Re: Filtered filters

Sam_SAS — Wed, 17 Jun 2020 13:57:19 GMT

Hello @mattneo ,

In the options for the drop-down list, do you see an "Initially select first item" option? I believe this should get the behavior you want when Mailbox A is selected, but I'm not sure if there will be unwanted side effects.

I don't think there is another way to cause a control to automatically select an item.

Let us know if that helps.

Thanks,

Sam

Re: Filtered filters

mattneo — Thu, 18 Jun 2020 15:24:17 GMT

Hi Sam,
Thanks for the suggestion. Unfortunately "Initially select first item" did not work; nothing was selected in dropdownlist#2, even when "Mailbox A" was selected in dropdownlist#1.

Re: Filtered filters

Sam_SAS — Thu, 18 Jun 2020 15:31:49 GMT

Oh well. Thanks for following up. Someone else may have different ideas to try.

Sam