Sample 59907: Creating a title that contains filter values selected in a SAS® Visual Analytics report
Overview
Controls are used to filter a report. Sometimes reports contain a lot of controls, and you cannot easily see all of the selected values. This is especially true for controls that are inside of a container. This sample shows you how to use a button bar that displays the values from three drop-down list controls. Drop-down lists that do not contain a value are not represented in the button bar. Here is an example of what the button bar (on the right) looks like when a value is selected in all three drop-down lists (on the left):
For the purpose of this sample, the SASHELP.CARS table was loaded in to the SAS® LASR™ Analytic Server as a data source named Cars.
Create the report objects
- Create a new report and select the Cars data source.
- Add a button bar and three drop-down list controls to the report.
- Right-click each drop-down list control, and select Create Parameter.
- Create a parameter for Make (Make Parameter), Model (Model Parameter), and Origin (Origin Parameter).
Create the title
- Create a new calculated item and name it MakeTitle.
- Create an expression using conditional logic as shown in the following example:
Here is the text from the Text tab
IF ( 'Make Parameter'p Missing ) RETURN ' ' ELSE Concatenate(' Make:', 'Make Parameter'p)
- Repeat steps 1 and 2 to create ModelTitle and OriginTitle.
- Create a new calculated item and name it Title.
- The expression for the Title data item should check to see whether all of the values are missing. If they are, then set the Title value to No Filter. Here is what the expression looks like:
Here is the text from the Text tab
IF ( ( 'Origin Parameter'p Missing ) AND ( ( 'Model Parameter'p Missing )
AND ( 'Make Parameter'p Missing ) ) )
RETURN 'No Filter' ELSE Concatenate(Concatenate('MakeTitle'n, 'ModelTitle'n), 'OriginTitle'n)
- Select the button bar to make it the active object.
- Select the Roles tab.
- Add the Title data item to the Category role.
Additional resources
For links to all of the available documentation for SAS Visual Analytics, see the SAS Visual Analytics Product Documentation page.
These sample files and code examples are provided by SAS Institute
Inc. "as is" without warranty of any kind, either express or implied, including
but not limited to the implied warranties of merchantability and fitness for a
particular purpose. Recipients acknowledge and agree that SAS Institute shall
not be liable for any damages whatsoever arising out of their use of this material.
In addition, SAS Institute will provide no support for the materials contained herein.
These sample files and code examples are provided by SAS Institute
Inc. "as is" without warranty of any kind, either express or implied, including
but not limited to the implied warranties of merchantability and fitness for a
particular purpose. Recipients acknowledge and agree that SAS Institute shall
not be liable for any damages whatsoever arising out of their use of this material.
In addition, SAS Institute will provide no support for the materials contained herein.
Date Modified: | 2021-03-29 13:02:12 |
Date Created: | 2017-02-06 16:11:03 |
Operating System and Release Information
SAS System | SAS Visual Analytics | Microsoft® Windows® for x64 | 7.3 | | 9.4 TS1M3 | |
Linux for x64 | 7.3 | | 9.4 TS1M3 | |