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

Use Different variable on clearing filter

Reply
Regular Contributor
Posts: 181

Use Different variable on clearing filter

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?

Frequent Contributor
Posts: 115

Re: Use Different variable on clearing filter

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

Ask a Question
Discussion stats
  • 1 reply
  • 226 views
  • 0 likes
  • 2 in conversation