topic Re: Multiple Filters on a Single Field in SAS VA 7.5 in SAS Visual Analytics

Multiple Filters on a Single Field in SAS VA 7.5

ldenney — Sat, 07 Sep 2019 21:02:00 GMT

I need a report filter set up for 2 pages on my SAS VA Report and I would like to use 1 report filter for both pages. The field I would like to filter on (client) contains multiple client names as well as benchmarks.

Page 1 contains a crosstab for a single client. The second page has a line graph with 4 individual benchmark lines (these rarely change) and I would like to select an individual client to view on the graph with the benchmarks. I have no problem with page 1 with selecting client name and the crosstab displaying the correct information.. The second page with the graph, when I filter on the client name, I lose the 4 benchmarks on the graphs. There are 450 clients so using multiple selects from a list seems unwieldy.

Any help is appreciated!

Re: Multiple Filters on a Single Field in SAS VA 7.5

FredrikE — Mon, 09 Sep 2019 06:43:25 GMT

Hi!

One way you might solve this in is to create a calculated measure that get the value you want to show when then client name is the same as the selected one. You need a parameter that is assigned to the selection box. The formula could look something like this:

IF [parameter] = client_name then RETURN value

ELSE return .

THen use this calculated measure in your benchmark graph.

//Fredrik

Re: Multiple Filters on a Single Field in SAS VA 7.5

ldenney — Mon, 09 Sep 2019 21:06:44 GMT

Thank you! I will give this a try and let you know how it goes