topic Re: Multiple selections in another field in QlikView

Multiple selections in another field

vipingarg23 — Tue, 14 Nov 2017 11:59:17 GMT

Hi Team,

I have two listboxes. One is A and another one is also A but with alternate state test.

Here I want that If I select any value in A, it should automatically select that value in another one which contains alternate state. I applied a trigger and it is working fine for one value but not working for multiple value.

Please find the attached sample...

Re: Multiple selections in another field

tresB — Tue, 14 Nov 2017 12:01:42 GMT

Use search string expression like:

='('&GetFieldSelections(A,'|')&')'

Re: Multiple selections in another field

sunny_talwar — Tue, 14 Nov 2017 12:02:01 GMT

Try this for your trigger

='(' & Concat(DISTINCT Chr(34) & A & Chr(34), '|') & ')'

Re: Multiple selections in another field

vipingarg23 — Tue, 14 Nov 2017 12:14:55 GMT

Excellent and thank you for your quick reply.

Both are working fine...Thanks a lot sunny and Tresesco for your help.