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

Dependency between two filters in section prompt

Accepted Solution Solved
Reply
Contributor
Posts: 41
Accepted Solution

Dependency between two filters in section prompt

HI

 

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

 


Accepted Solutions
Solution
‎03-01-2016 10:33 AM
Regular Contributor
Posts: 199

Re: Dependency between two filters in section prompt

Posted in reply to SomanDavuluri

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 )

 

Or

 

 

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

 

 

Let me know......

 

 

Thanks & Regards,

Teja Surapaneni

View solution in original post


All Replies
Solution
‎03-01-2016 10:33 AM
Regular Contributor
Posts: 199

Re: Dependency between two filters in section prompt

Posted in reply to SomanDavuluri

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 )

 

Or

 

 

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

 

 

Let me know......

 

 

Thanks & Regards,

Teja Surapaneni

Contributor
Posts: 41

Re: Dependency between two filters in section prompt

Posted in reply to SomanDavuluri

HI Teja ,

 

 

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

 

 

regards

Soman

Community Manager
Posts: 565

Re: Dependency between two filters in section prompt

Posted in reply to SomanDavuluri

SomanDavuluriI'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

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 3 replies
  • 446 views
  • 2 likes
  • 3 in conversation