BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
je9
Fluorite | Level 6 je9
Fluorite | Level 6

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.

Skjermbilde.PNG

1 ACCEPTED SOLUTION

Accepted Solutions
FredrikE
Rhodochrosite | Level 12

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 

View solution in original post

5 REPLIES 5
SASKiwi
PROC Star

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.

FredrikE
Rhodochrosite | Level 12

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 

je9
Fluorite | Level 6 je9
Fluorite | Level 6

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

FredrikE
Rhodochrosite | Level 12

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

 

//Fredrik

je9
Fluorite | Level 6 je9
Fluorite | Level 6

Thank you! Brilliant, it worked!

sas-innovate-2024.png

Don't miss out on SAS Innovate - Register now for the FREE Livestream!

Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.

 

Register now!

Tips for filtering data sources in SAS Visual Analytics

See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 5 replies
  • 857 views
  • 2 likes
  • 3 in conversation