Button to reset all text input filters in SAS VA, ideally combined with a CSV filter

Milton — Thu, 04 Jan 2024 00:07:47 GMT

Using SAS Viya 3.05, VA 8.5.2

Experience level: Novice

Hi, and thanks for any help.

I am successfully using the method noted here to reset most filters in a VA report using a single button:

https://communities.sas.com/t5/New-SAS-User/One-button-to-reset-all-filters-SAS-VA-8-2/td-p/523400

https://communities.sas.com/t5/SAS-Visual-Analytics/Button-on-VA-Report-to-quot-Clear-all-Filters-quot/td-p/273046

However, it doesn't seem to work for text input filters. Is there any way to apply this, or a similar solution, to a text input filter?

Ideally, I'd combine this with a CSV filter, using an approach similar to this:

https://communities.sas.com/t5/SAS-Visual-Analytics/Filter-list-object-using-multiple-text-box-entries/td-p/801091

The end result I'm looking for is a CSV text box (contains) filter, where the user can enter 1-20 filters, i.e.

Filter = "Toyo, Nissan, Honda, Chev"

Returns Toyota, Nissan, Honda, Chevy, Chevrolet

Which can then be reset using a button.

But if I can't achieve that, a series of text input filters will be my fallback...but I still can't seem to get text boxes to reset with the button

Code for resetting filter:

parameter: reset_all, reset_tab, reset_subtab

calc_field_1 (repeated for tab, subtab):

IF ( 'reset_all'p = NOT)

RETURN 'reset_filters'

ELSE 'resetting'

calc_field_2 (actual filter):

IF ( ( 'reset_all'n = 'reset_filters' ) OR

( 'reset_tab'n = 'reset_filters' ) OR

( 'reset_subtab'n = 'reset_filters' ) )

RETURN 'car_make'n

ELSE 'click again to reset'

Advanced Filter Code for CSV filter:

'car_make'n Contains GetWord ( 'car_make_input'n,1 ) OR

( 'car_make'n Contains GetWord ( 'car_make_input'p,2 ) AND ( GetWord ( 'car_make_input'p,2 ) NotMissing ) OR

( 'car_make'n Contains GetWord ( 'car_make_input'p,3 ) AND ( GetWord ( 'car_make_input'p,3 ) NotMissing ) OR

... to 20

This is the simplified version, there's also text tidy up stuff (UpCase, etc.) embedded as well.

WHY am I doing this, and why can't I use a different approach?

I have dashboard with a LOT of filters, spread across multiple tabs, subtabs, scrolling containers, etc. to allow the users to slice and dice many different ways. Many of the input values are narrative text and/or have numerous values, so drop downs wouldn't work. It'd be horrendous for the users to try and hunt down all the filters to manually reset them, and I want to provide the option to reset all, reset tab, reset subtab, etc.

Thanks very much!

topic Button to reset all text input filters in SAS VA, ideally combined with a CSV filter in SAS Visual Analytics

Button to reset all text input filters in SAS VA, ideally combined with a CSV filter