Subtract lists to produce another containing only the unique items of the first list that aren't also in the second

[ADAJALAN]

I don’t know anymore what formula to use to get this to work. What I want is from a list() group - the list() column will return the remainder of the right-hand side list.

it doesn’t work like this photo I’m showing,

can someone help me???

[Steve]

Original post:

How to filter selection according to criteria Questions

"I have a transaction form like the following, The problem is I only want to display the months that have not been paid, currently it still displays the entire month selection And in the form that currently exists, I only managed to give a valid error if the month period has been paid” [Presentation1]

[Steve]

For reference:

help.appsheet.com

List Subtraction

Subtract lists to produce another containing only the unique items of the first list that aren't also in the second.

[Steve]

Please post a screenshot of the complete expression you’re using.

[ADAJALAN]

Please advise

[Steve]

Have you used Test to confirm your expression produces the expected results?

[ADAJALAN]

Yes, I have used test…
but the results are not as expected.

for with one item, like screenshot “Jan” can work, but with reduction Jan,Feb,Mar

Reduction doesn’t work

[Steve]

Wrap your SELECT() expression with CONCATENATE() and SPLIT():

SPLIT(CONCATENATE(SELECT(...)), " , ")

See also:

help.appsheet.com

CONCATENATE()

Merged text from parts

help.appsheet.com

SPLIT()

List from text

[ADAJALAN]

it works @Steve…
thank you,

I had thought about using split, but was confused about how to combine it.

[SkrOYC]

SkrOYC:

Seems like you were playing with the Item separator. By default it is " , " . Leave it as default

Could you check this anyway? Just to make sure we are not fixing a problem made initialy by changing the Item separator so that others could avoid it in the future

[ADAJALAN]

like this

[SkrOYC]

Thanks.
Seems like Item separator is "," instead of " , "

[SkrOYC]

Please post your [Pembayaran Bulan] config.
Like this:

Seems like you were playing with the Item separator. By default it is " , ". Leave it as default

[Steve]

Good point!