No Data Qualified warning message
This condition is called No Data Qualified or NDQ. There are a number of ways to handle or prevent this situation:
Enabling Filter Dependencies will prevent filters from being configured that would cause “No Data Qualified”.
For example, choosing Beverages as the Category and Boston Crab Meat as the Product Name would result in NDQ since there are no products named Boston Crab Meat in the Beverages Category. With Allow Filter Dependencies enabled Exago will only show Products that are in the Category selected.
With Allow Filter Dependencies disabled, all products regardless of Category are available in the dropdown
With Allow Filter Dependencies enabled, only those products in the Category previously selected in the dropdown are available
To enable filter dependency, the system administrator must:
A lesser known feature of this application is the ability to execute a report even if No Data is Qualified. This functionality is useful in situations where a user still wants to see the report or when a custom message is conditionally set for when no data is qualified. When using Show Report instead of Show Message, the only items that will appear in the report are those that aren’t connected to the data.
Choosing Show Report from No Data Qualify Display Mode in the Report General Options dialog
This functionality is commonly used when reports are being shown via a Dashboard and users want at least the title to appear, and/or display a custom message rather than the intrusion of an error message on the Dashboard.
When using display mode Show Report it may be preferable to leave a custom message for the viewer upon execution. This can be done using Custom Formatting.
Using a built in function, Exago can conditionally suppress a cell to only show when the report has returned NDQ.
IsNoDataQualified() = False()
Upon execution, all the elements that are not data as well as the conditional message should appear within the execution.
For more information about Conditional Formatting, refer to the Advanced Reports: Cell Formatting article.