topic Re: How to insert a filter input box where user can input Multiple values to filter in SAS Visual Analytics

How to insert a filter input box where user can input Multiple values to filter

Picanion — Fri, 24 May 2019 11:46:29 GMT

I have a report with customer ID, customer Name, and account count field.. i have inserted a cross tab to display customer Name wise account count. It has more than 1000 records (rows). Now i wast to insert a input field, where user can type/paste a set of names (e.g. Alfed,Carol, Henry) and the corresponding value should appear there in cross tab or graph.

I have already tried 'Text-input' option but it could take only one value to filter, not taking multiple.

We would like to paste set of customer name or upload a excel/csv file to filter out the report in the view. User can accordingly view interested record and download if needed.

you may consider below data for example... and need a filter button on dashboard of SAS VA to filter data by names.

data WORK.CLASS(label='Student Data');
   infile datalines dsd truncover;
   input Name:$8. Sex:$1. Age:32. Height:32. Weight:32.;
 datalines; Alfred M 14 69 112.5
 Alice F 13 56.5 84
 Barbara F 13 65.3 98
 Carol F 14 62.8 102.5
 Henry M 14 63.5 102.5
 ;;;;

Regards,

Partha

Re: How to insert a filter input box where user can input Multiple values to filter

VDD — Fri, 24 May 2019 12:48:48 GMT

are you asking to control user access at the record level rather than the table level?

Re: How to insert a filter input box where user can input Multiple values to filter

Sam_SAS — Tue, 28 May 2019 13:51:39 GMT

Hello Partha,

I believe the answer in this thread:

https://communities.sas.com/t5/SAS-Visual-Analytics/How-to-use-text-input-for-multiple-selections-in-SAS-VA-7-3/m-p/561883#M12543

might help you. I am not sure about pasting in a large number of names, but it should work for reasonably small numbers of input values.

Let us know.

Thanks,

Sam

Re: How to insert a filter input box where user can input Multiple values to filter

Picanion — Tue, 28 May 2019 15:56:32 GMT

I meant table level which is displayed

Re: How to insert a filter input box where user can input Multiple values to filter

Picanion — Mon, 03 Jun 2019 07:20:40 GMT

Hello, I have more than 1000 record and would like to filter on multiple selection. This approach is good for 4-5 records only.

Re: How to insert a filter input box where user can input Multiple values to filter

Sam_SAS — Mon, 03 Jun 2019 14:45:00 GMT

Hello Partha, did you look at my post in the thread I linked above?

The number of rows in your data is not an issue, only the maximum number of selections that will be entered at one time.

Re: How to insert a filter input box where user can input Multiple values to filter

Picanion — Tue, 04 Jun 2019 10:17:12 GMT

Yes, I have checked that too. in my case input can also go beyond 100 records. What to do in that case?

Re: How to insert a filter input box where user can input Multiple values to filter

Sam_SAS — Tue, 04 Jun 2019 12:51:47 GMT

More than 100 inputs? I don't think there is any way to do that in the VA reporting interface.

In your data preparation, I think you could do a join to keep just the records that match the names list. But that is not a self-service approach that non-privileged users could use.