topic Re: Select all but one Values via Filter Formula in App Development

Select all but one Values via Filter Formula

Tim_G — Mon, 18 Dec 2023 10:28:39 GMT

Hello there,

I would like to set up a new bookmark. There I woul like to select all but one values in a specific dimension.

Usually if you want to select specific values in the dimension you go like this:

=[Dimension]={'0'}

However I woul like to select all but the zero. I tried something like this but it does not work:

{"[Dimension]={"<>[Dimension]={'0'}"}

Anybody has an idea?

vincent_ardiet_ — Mon, 18 Dec 2023 11:02:24 GMT

You can try just with:
=Dimension<>'0'

TcnCunha_M — Mon, 18 Dec 2023 11:02:27 GMT

Hi

Use "-= " value you want

Tim_G — Mon, 18 Dec 2023 11:13:12 GMT

Does not work either with <> or -=. If I do so only the zeros are selected which I want to avoid. Does not make sense to me:

[Offene Menge] is my Dimension and is a number, including negative values. Omitting the brackets {} gives an error with no selected values.

vincent_ardiet_ — Mon, 18 Dec 2023 12:17:11 GMT

First clear all selections and type =[Offene Menge]<>0

Tim_G — Mon, 18 Dec 2023 13:10:04 GMT

Works now. That was a variant I missed during trial an error. Thanks!

F_B — Mon, 18 Dec 2023 13:47:55 GMT

If you select the value zero from your filter,

then, clicking on the three points you can use the filter option

-excluded-