Hello everyone,
When a filter is applied (e.g., for a specific source system or company code), other filters still display values outside the selected scope with 0 values.
Is there a way to hide these values completely instead of showing them as 0?
Solved
Hide zero-value entries in filters outside selected filter scope
Best answer by Amishee Choksi
Hi Chetan,
We cannot hide those values specifically, they will continue to show the 0 value.
Is there a specific reason you want to hide these values?
Hi Chetan,
We cannot hide those values specifically, they will continue to show the 0 value.
Is there a specific reason you want to hide these values?
+17You may try by using a Forced Filter https://docs.celonis.com/en/filter.html#id681788
If a regular filter is set as a sheet or component filter, the affected Dropdown and Button Dropdown components still show all available values. If only those values which respect the filter should be displayed and selectable, a forced filter can be used. Analysis filters are forced by default.
PQL goes something like this
FILTER FORCED "Table"."Country" IN ('DE','US');
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.