how to exclude values in Listboxes in alternate state

[parul_mehta]

I have 4 different list boxes . they are created using alternate states.

Currently same data is showing in all four list boxes as in the screenshot

and it is possible to select the same value in all 4.

Is there a way to delimit the data which was selected in state1 should not be displayed in the other list boxes which are in different states?

Data selected in one list box should be omitted from the others, and hence not available for selection

[sunny_talwar]

I think it is possible, would you be able to share a sample to try it out before proposing anything?

[antoniotiman]

Hi Parul,

try in List Box Expression

=Aggr(Only({State2-State1} Field),Field)

=Aggr(Only({State3-State1} Field),Field)

=Aggr(Only({State4State1} Field),Field)

Regards,

Antonio

[asgardd2 · Accepted solution]

Hello!

If i understand correctly, you need this functionality.

Check my attachment.

[parul_mehta]

Thanks Anton, The qvw worked.

How to edit the expression for multiple states

For S1, I want to exclude the values in S2 S3 S4

and likewise for others

[asgardd2]

Maybe this qvw will help you.