Use Different variable on clearing filter

Ujjawal — Mon, 12 Dec 2016 17:03:10 GMT

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?

Re: Use Different variable on clearing filter

mfab — Fri, 30 Dec 2016 08:35:00 GMT

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

topic Use Different variable on clearing filter in SAS Visual Analytics

Use Different variable on clearing filter

Re: Use Different variable on clearing filter