Passing a parameter through an advanced filter

sseanhennessyy — Fri, 26 Oct 2018 16:40:11 GMT

So this one is a little complex and I'm not sure if it can be done or not. I'm attempting to create a report where the user can enter a date in CYYMMDD format to pass through an advanced filter. Here is the filter:

AND [ Policy Effective Date =< parameter

[ Policy Expiration Date >= parameter

Both Policy Effective Date and Policy Expiration Date are in the same CYYMMDD format.

The filter works when I create a custom parameter for a static value, however I want the report user to be able to change that parameter value through a text input control. Is this possible? Can a user change a parameter value through a text input option?

Re: Passing a parameter through an advanced filter

SASKiwi — Sun, 28 Oct 2018 19:49:45 GMT

In the Role tab of the Text Input object you can assign the field in the object to a parameter. This will allow you to change the date value and have it feed the parameter.

topic Passing a parameter through an advanced filter in SAS Visual Analytics

Passing a parameter through an advanced filter

Re: Passing a parameter through an advanced filter