Problem Note 67216: Advanced filters in SAS® Visual Analytics do not display more than 1,000 categorical values
When you create an advanced filter on a category data item that contains several distinct values, only the 1,000 most frequent values are listed. So, those are the only values that can be chosen in the filter window.
For example, you encounter this issue when you complete steps similar to the following:
- Create a new report and use a data source that contains a category data item with more than 1,000 values.
- Add a list table and drag the category data item in it.
- Select the list table, click the Filters tab on the right menu, and then select Advanced Filter.
- Choose an operator such as IN or NOT IN and add the category data item:
- Click the (none selected) button to choose your values. The following message is displayed: “Only the 1,000 most frequent values are listed.”
In this scenario, you cannot add unlisted values by using the Filter field.
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 | 8.5 | 9.4 TS1M7 | Viya |
Microsoft® Windows® for x64 | 7.51 | 8.5 | 9.4 TS1M7 | Viya |
*
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-02-04 13:11:45 |
Date Created: | 2021-01-13 10:46:19 |