topic Re: can we hide and show columns from list table based on filters in SAS Visual Analytics

can we hide and show columns from list table based on filters

ashishj816 — Fri, 24 Dec 2021 07:37:06 GMT

Hi All,

Based on filters can we hide and show columns which are present in cross tab.

Re: can we hide and show columns from list table based on filters

Kurt_Bremser — Fri, 24 Dec 2021 10:25:26 GMT

Please provide the code that creates the cross tab, and tell us which columns you do not want, and the logic for filtering them out.

Providing usable source data (data step with datalines) will most probably speed up the process of finding a useful answer.

Re: can we hide and show columns from list table based on filters

ashishj816 — Mon, 03 Jan 2022 11:29:38 GMT

This will be on SAS VA Part in Dashboard

Re: can we hide and show columns from list table based on filters

Kurt_Bremser — Mon, 03 Jan 2022 15:08:25 GMT

I moved your question to the Visual Analytics community. Since I do not use that product, I won't be of much help here.

Re: can we hide and show columns from list table based on filters

Sam_SAS — Mon, 03 Jan 2022 16:04:47 GMT

Hello,

I don't think you can hide the entire column (including the column heading.)

What you can do is make all of the values missing, which will cause the table/crosstab to aggregate as if the column were not there.

Here is a nonsense example with SASHELP.CARS:

Let's say we want to ignore the Drivetrain column when "Asia" is selected in the button bar.

First we make a character parameter and assign it to the button bar.

Then we create a calculated item that uses that parameter:

IF ( 'Parameter 1'p NotIn ('Asia') )
RETURN 'DriveTrain'n
ELSE ''

Now when we select "Asia" in the button bar, we get this:

If you want the button bar to ONLY set the parameter and not also filter the data, be sure to place the button bar in the body of the report page and not in the prompt area. That would give this result, which might be closer to what you wanted:

It's not exactly what you are looking for, but I hope this might help.

Thanks,
Sam