topic Filtering-out a list of values in an expression in App Development

Filtering-out a list of values in an expression

Anonymous — Sat, 30 Sep 2017 15:10:17 GMT

I need to hide multiple values for a dimension using an expression. We do not want to limit this data on loading, so this is not an option.

I've successfully used <> for a single value, but do not know how to handle multiple values.

swuehl — Sat, 30 Sep 2017 21:30:12 GMT

=If( Not Match(FIELD, 'Value1','Value2','Value3'), FIELD)

as calculated dimension or using set analysis in every aggregation function in your expressions:

=Sum({<FIELD -= {'Value1','Value2','Value3'} >}Value)

Anonymous — Sat, 30 Sep 2017 21:47:23 GMT

Thanks!