topic Re: Dependency between two filters in section prompt in SAS Visual Analytics

Dependency between two filters in section prompt

SomanDavuluri — Fri, 26 Feb 2016 07:04:01 GMT

Can anyone help me on working with dependency on filters in section prompt

i have city and location filters placed in section prompt

where if i select city , location has to be mapped .with the respective city .

anyone can help on creating the dependency of filters both placing on section prompt.

regards

Re: Dependency between two filters in section prompt

TejaSurapaneni — Fri, 26 Feb 2016 07:12:51 GMT

Hello Soman,

Create Character Parameter.

assign the parameter to Dropdownlist1 (city).

for fDropdown list 2 (location) you have to put conditional filter (Which is on Right Handed side Pane FILTERS).

IF ( 'City'n Contains 'City..'p )
RETURN ( 'location'n = 'location'n )
ELSE ( 'location'n Missing )

IF ( 'City'n Contains 'City..'p )
RETURN ( 'location'n NotMissing )
ELSE ( 'location'n Missing ).

Let me know......

Thanks & Regards,

Teja Surapaneni

Re: Dependency between two filters in section prompt

SomanDavuluri — Tue, 01 Mar 2016 05:33:14 GMT

HI Teja ,

Thank your for the solution , its working out ...

regards

Soman

Re: Dependency between two filters in section prompt

AnnaBrown — Tue, 01 Mar 2016 14:28:41 GMT

SomanDavuluri, I'm glad you found some useful info! If Teja's reply was the exact solution to your problem, can you "Accept it as a solution"? Or if it was particularly helpful, feel free to "Like" it. This will help other community members who may run into the same issue know what worked.

Thanks!
Anna