topic Re: Button for removing zeros for column in SAS Visual Analytics

Button for removing zeros for column

je9 — Fri, 01 Feb 2019 14:00:48 GMT

Hi. In SAS VA Report Designer, is it possible to create a button with the function of removing all zeros for a given column?

I know it is possible to use a display rule to set the text color to be the same as the background color but is it possible to have a button on the report that would activate this display rule?

More specifically, is there a way to have a button the user can click to make all zeros in the middle column below disappear.

Re: Button for removing zeros for column

SASKiwi — Fri, 01 Feb 2019 22:37:31 GMT

As far as I'm aware there is no way to switch display rules on and off. They are created and assigned in Report Designer. The best I can think of is having two versions of the same report, one with zeroes displayed and one without.

Re: Button for removing zeros for column

FredrikE — Sat, 02 Feb 2019 16:34:13 GMT

Hi!

I should be possible.

The easiest if you add a tab containers with tabs and then add two tables, one in each tab. in the first one you show everything and in the second you hide the 0 using a display rule.

Another way thou a bit more complicated would be to first create a custom dimension with two values, "show/hide". This can be done by using an existing dimension as input and create two groups.

Then add a button bar with dimension as category.

Create a text parameter that you add to the button.

Then create a calculated measure that checks the value of the parameter and sets the value to . if value of parameter is "hide" and if value is "show" set the value of the original variable that you are using in the table in tour example.

Then create a display rule that change color on values ".", the one you created in your calculated measure.

Maybe this can help you some what 🙂

//Fredrik

Re: Button for removing zeros for column

je9 — Fri, 08 Feb 2019 08:40:20 GMT

Hi,

Thanks for the response!

What do you mean by "dimension"? I am using SAS VA Designer v7.4. I am not entirely sure I have or have used dimensions.

- Jenine

Re: Button for removing zeros for column

FredrikE — Fri, 08 Feb 2019 16:33:47 GMT

Sorry if I confuse you, dimension is the same as category, better 🙂 ?

//Fredrik

Re: Button for removing zeros for column

je9 — Mon, 11 Feb 2019 18:43:39 GMT

Thank you! Brilliant, it worked!