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
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
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
HI Teja ,
Thank your for the solution , its working out ...
regards
Soman
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
April 27 – 30 | Gaylord Texan | Grapevine, Texas
Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!
See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.
Find more tutorials on the SAS Users YouTube channel.