topic Re: Select multiple values from listbox and then use match functions in QlikView

Select multiple values from listbox and then use match functions

yzhang88 — Wed, 25 Nov 2020 16:16:04 GMT

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.

Re: Select multiple values from listbox and then use match functions

Anil_Babu_Samineni — Thu, 19 Jul 2018 15:14:05 GMT

How about this?

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

Re: Select multiple values from listbox and then use match functions

yzhang88 — Thu, 19 Jul 2018 15:22:01 GMT

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

Re: Select multiple values from listbox and then use match functions

yzhang88 — Fri, 20 Jul 2018 18:39:22 GMT

figured out the solution, it returns the correct result.

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