Exploring, modeling, 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: 196

Re: Dependency between two filters in section prompt

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: 196

Re: Dependency between two filters in section prompt

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

HI Teja ,

 

 

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

 

 

regards

Soman

Community Manager
Posts: 486

Re: Dependency between two filters in section prompt

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
  • 431 views
  • 2 likes
  • 3 in conversation