Select multiple values from listbox and then use match functions

[yzhang88]

Can I select multiple values from listbox and then use match function in expression? For example, I select 'Code' from the listbox with multiple values 'A' and 'B', and then in a chart expression, I want to use  =if(match(Code, 'A','B', 'C','D'), 1, 0). how to do this with multiple selections? I tried with single selection value, it returns 1, but multiple selections always returns 0.

[Anil_Babu_Samineni]

How about this?

If(GetPossibleCount(Code)>1, 1,0)

[yzhang88]

Thank you for quick reply, while I need check the value of selections here with my project.

[yzhang88 · Accepted solution]

figured out the solution, it returns the correct result.

=if( wildmatch ( GetFieldSelections (Code, ','), '*A*','*B*', '*C*','*D*'), 1, 0)