Display a list with more than one criteria

ADAJALAN · 12-09-2021 05:27 AM

how can i make a list from reference column, with some keywords.

currently I can only do one action like in GIF which is fetching list from another table,

for example, when in a category I select more than one item, the list will display all lists of the category I selected.

this is formula which use for list :

select(Unit Price[Item],[Category]=[_THISROW].[Category])

Aurelien

Hi @ADAJALAN

What about:

SELECT(Unit Price[Item],
  ISNOTBLANK(
    INTERSECT([Category],[_THISROW].[Category])
  )
)

ADAJALAN

that is the formula I use in the new virtual column like this photo,
to get a list item from the value in the category . column

Aurelien

OK.
And that works, or that doesn’t ?

which formula ?

ADAJALAN

it works, but only with one criteria i select from [category] column,

If I want to display a list of several criteria from the [category] column, for example [category]=Panel,Cable

Then the list will display a list of panels and cables

what do I have to do ?

Aurelien

Did you try my suggestion ?

I write it again, with a more explicit category name:

SELECT(Unit Price[Item],
  ISNOTBLANK(
    INTERSECT(
      [CategoryColumn_FromUnitPriceTable],
      [_THISROW].[CategoryColumn_FromCurrentTableIfEnumList])
  )
)

ADAJALAN

doesn’t seem to be working

Aurelien

Assuming:

[_THISROW].[Category] is an enumList
And Enumlist are interpreted as text

Try:

SELECT(Unit Price[Item],
  ISNOTBLANK(
    INTERSECT(
      LIST([Category]),
      SPLIT(
        CONCATENATE([_THISROW].[Category]),
        " , "
      )
    )
  )
)

Edit : correction of expression

ADAJALAN

awesome, it works…

or this also works

SELECT(Unit Price[Item],
ISNOTBLANK(
INTERSECT(
LIST([Category]),
[_THISROW].[Category])
)
)

and now i have a new problem, how can i download or export from this list ?

ADAJALAN

Aurelien

That’s another question.
I’m pretty sure you will find the answer at looking in previous posts on this community.
I suggest you post a new thread if you still don’t get it

Just in case that may help too:

ADAJALAN

Okay, no problem…
thanks for the help and advice.