BookmarkSubscribeRSS Feed
Ujjawal
Quartz | Level 8

I want to use the other variable when filter is cleared from dropdown. In other words, I want to refer the different variable when data is shown at overall level (which means clearing filter). Is it possible via parameter?

1 REPLY 1
mfab
Quartz | Level 8

Sure, that should be possible:

 

  • create a parameter from your drop-down list
  • create new filter on the element you want to filter on
  • edit the filter
  • use the boolean operator IF...ELSE
  • use the parameter in IF part with a comparison operator (I would suggest something like 'missing')
  • insert your filter criteria if the parameter is missing (that means, no value selected in drop down)
  • insert your filter criteria if the parameter is not missing (something like xyz contains parameter, xyz = parameter, etc.)

I have used a text box for something like this. I think this should also work with a drop-down list.

 

Cheers,

Michael

SAS Innovate 2025: Call for Content

Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!

Submit your idea!

Tips for filtering data sources in SAS Visual Analytics

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.

Discussion stats
  • 1 reply
  • 947 views
  • 0 likes
  • 2 in conversation