Comparing two lists

[superlipe]

Hi!

I'm working on a filter for dietary restrictions.

In one table I have the recipes and a column with a list of the allergens [Dieta].

In the filter table I have a EnumList with all the allergens [Filtro].

In a Form View I let the user select all their allergies to generate the [Filtro] list, so I can use a LINKTOFILTEREDVIEW.

I came with the following expression for the action:

LINKTOFILTEREDVIEW("PratosFiltrados", NOT(CONTAINS([Dieta], [_thisrow].[Filtro])))

It works only if [Filtro] is comprised of one selection. If the user selects multiple allergies, the expression does not work.

Any light?

[superlipe]

Complementing the question:

The desired result would be the selection of recipes which does not contain any of the allergens selected in the [Filtro].

[SkrOYC]

[Filtro] es un EnumList
[Dieta] es también una lista

En teoría, si cruzas ambas listas, esperas que no tengan nada en común para poder pasar el filtro.

Prueba con:

ISBLANK(
  INTERSECT(
    [Dieta],
    [_THISROW].[Filtro]
  )
)

[superlipe]

No good. 
Result: INTERSECT does not accept a list of list.

[SkrOYC]

Pues ese es otro problema, indícanos la configuración de [Dieta] y [Filtro]

[superlipe · Accepted solution]

Hello Skr0YC

I added SPLIT() to both columns in your solution and it work. Thank you for the input!

[SkrOYC]

Share us the config so that we can see why you are using a List of Lists.

Also notice that just using SPLIT() won't always solve the issue or may even just look like it was solved