Problem Note 68216: An advanced filter with multiple values for numeric parameters is not listed on the Filters tab in SASĀ® Visual Analytics
An issue might occur with an advanced filter in SAS Visual Analytics. The advanced filter might disappear from the Filters tab in a scenario where the filter is based on numeric parameters with multiple values. However, even though the filter is missing from the list on the Filters tab, the filter still works correctly.
You can encounter this issue after you complete steps similar to the following, and your report is based on a data source that contains a measure with years:
- Add a list control and a cross table into Page1.
- Create a numeric parameter with multiple values.
- Switch the measure data item from Numeric to Category, and add it as the Category role for the list control.
- Add the parameter as the Parameter role for the list control.
- Add the measure data item as the Columns role for the cross table.
- Select the cross table and add a filter so that the cross table is filtered by the parameter in the list control:
IF ( 'Par'p In (.) )
RETURN ( 'measure'n = Year(DatePart(Now())) )
ELSE ( 'measure'n In ('Par'p) )
As soon as you click OK in the Advanced Filter window, the filter works correctly. However, it might disappear from the Filters tab in the panel on the right side:
Also, when you switch between tabs on the cross table (for example, between Actions, Options, Roles), the New filter option might appear instead of the options related to other tabs:
Click the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
SAS System | SAS Visual Analytics | Linux for x64 | 7.51 | | 9.4 TS1M7 | |
*
For software releases that are not yet generally available, the Fixed
Release is the software release in which the problem is planned to be
fixed.
Type: | Problem Note |
Priority: | high |
Date Modified: | 2021-08-13 16:46:16 |
Date Created: | 2021-08-06 06:05:17 |