Conditional filter


#1

Is there the possibility to have a case when on filter components?
Many thanks.


#5

Hello Catia,

it is possible to use a CASE WHEN statement in a filter statement, however this is only useful in relatively few use cases. One option would be if you wanted to use it in a function e.g.

FILTER
“TABLE”.“DATE_COLUMN” BETWEEN ADD_DAYS(TODAY(),
CASE WHEN … END
) AND TODAY()

To limit the analysis to values that lie in a certain date range, conditional on other field entries.

Best,
Henry