Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
figured out the solution, it returns the correct result.
=if( wildmatch ( GetFieldSelections (Code, ','), '*A*','*B*', '*C*','*D*'), 1, 0)
How about this?
If(GetPossibleCount(Code)>1, 1,0)
Thank you for quick reply, while I need check the value of selections here with my project.
figured out the solution, it returns the correct result.
=if( wildmatch ( GetFieldSelections (Code, ','), '*A*','*B*', '*C*','*D*'), 1, 0)