Filter null values (-) from a dropdown in IBC

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:

Empty_value

I have tried additional filters like:
FILTER “ACTIVITY_TABLE”.“COLUMN” !=’’;
FILTER “ACTIVITY_TABLE”.“COLUMN” !=’ ‘;
FILTER “ACTIVITY_TABLE”.“COLUMN” !=’-’;

Best regards,
Paul Velthuis

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

1 Like

Hi David,

What about the opposite? I’m 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

Hi Alex,

could this be your issue: Unable to make NULL Value as the selector in an OLAP Field ?

Best
David