Option to Filter all

AppSheet AppSheet Q&A
1

Hello Guys, I created this filter to filter by year and supplier, and I want it to show me the option to filter all suppliers but it only get one of each, how do I do it? thanks

deletar.png
deletar.png1723×774 18.4 KB

Row FIlter Condition:

ISNOTBLANK(
FILTER(“Filtro”,
AND(
IN([_THISROW].[ANO], Filtro[Ano]),
IN([_THISROW].[MES], Filtro[Mês]),
IN([_THISROW].[FORNECEDOR], Filtro[Fornecedor]))
)
)

2

Change the ENUM formula in Filtro[Fornecedor] to be

LIST("All")+Table[Column]

then change the slice formula to be

ISNOTBLANK(
   FILTER("Filtro",
      AND(
         IN([_THISROW].[ANO], Filtro[Ano]),
         IN([_THISROW].[MES], Filtro[Mês]),
      OR(
         Filtro[Fornecedor]="ALL",
         IN([_THISROW].[FORNECEDOR], Filtro[Fornecedor]))
      )
   )
)

Simon, 1minManager.com

1 Like
3

Error:

Cannot compare List with Text in (Filtro[Fornecedor] = “ALL”)

4

Replace

Filtro[Fornecedor]=“ALL”,

with

IN(“All”,Filtro[Fornecedor]),

1 Like
5

turned a button :disappointed_face:

ddd.png
ddd.png1517×757 72.7 KB

6

this solution solves it but I will have to create another column, can I choose all or one of each in the same column?

7

Collumns:
SELECT(Dados[FORNECEDOR], TRUE) + LIST(“All”)

Slice:
AND(
IN([_THISROW].[ANO], Filtro[Ano]),
IN([_THISROW].[MES], Filtro[Mês]),
OR(
IN(“All”, Filtro[Fornecedor]),
IN([_THISROW].[FORNECEDOR], Filtro[Fornecedor])
)
)

:blush: