IBM Support

The number of rows retrieved exceeds the limit of 5000 message filering visualization in interactive viewer

Troubleshooting


Problem

Selecting the filter icon to filter a visualization produces a warning:
image 7427

Cause

To be able to filter a visualization on a data item that does not appear on the chart, you can include the data item in the Extra Data area in the chart.  Below, <Product> has been added to the Extra Data area.
image 7429
If this data item results in more than 5000 values, you receive the warning when clicking on the filter icon.  Below, <Order number> results in more than 5000 values.
image 7428

Resolving The Problem

Ensure the data item included in the Extra Data area does not result in more than 5000 values.

Document Location

Worldwide

[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSTSF6","label":"IBM Cognos Analytics"},"ARM Category":[{"code":"a8m500000008d78AAA","label":"Reporting"}],"ARM Case Number":"TS004522999","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Version(s)"}]

Document Information

Modified date:
07 December 2020

UID

ibm16379154