Skip to main content
Question

Filter null values (-) from a dropdown in IBC

  • May 14, 2020
  • 3 replies
  • 7 views
P
Level 8
Hello Celonis and Celonis Users, There is a dropdown we like to create without showing the null values, The dropdown is based on the activity column, so some activities have null values in them. If I filter with: FILTER ACTIVITY_TABLE.COLUMN IS NOT NULL; I see the null value drop to the bottom: I have tried additional filters like: FILTER ACTIVITY_TABLE.COLUMN !=; FILTER ACTIVITY_TABLE.COLUMN != ; FILTER ACTIVITY_TABLE.COLUMN !=-; Best regards, Paul Velthuis

3 replies

D
Level 1
Forum|alt.badge.img+2
Hi Paul, you can use FILTER FORCED for this. It is documented in the FILTER documentation. So the following filter query will work: FILTER FORCED "ACTIVITY_TABLE"."COLUMN" IS NOT NULL; Cheers David
A
Level 1
  • alex.hellw
  • Level 1
  • May 19, 2020
Hi David, What about the opposite? Im in need of a table that filters out all values that are not null, but this FILTER FORCED logic reversed does not seem to work. Any thoughts? Thanks, Alex
D
Level 1
Forum|alt.badge.img+2
Hi Alex, could this be your issue: Unable to make NULL Value as the selector in an OLAP Field ? Best David
Community Code of ConductAccessibility statement