topic Is multiple selection possible across various selection boxes of name field ? in QlikView

Is multiple selection possible across various selection boxes of name field ?

Shubu005 — Tue, 31 Jul 2018 09:03:19 GMT

Hi All,

i have 2 fields, name and id.

i have a situation below where i have separated the name field base on the last 3-4 char.

i want to do multiple selection from 2 different selection boxes, for example: from field in m3 = 'martis in m3' and from field in m2 = 'zilong in m2' and after selection their id should concatenate in text box like below screenshot.

pleas find the sample attachment below.

Please Help me with this.

Thank you.

Re: Concatenate possible id when multiple selection on name field separated using wild match

vamsee — Wed, 01 Aug 2018 15:52:23 GMT

Hi Shubham,

You are working on the same column and splitting it into multiple list boxes.

Create the same columns on the backend. You would notice that the records in m2 are empty when you select m3 values. Please see the below image.

I have enabled SET null as value option. NULL handling in QlikView

Now you would be able to select.

PFA.

Thanks

Vamsee

Re: Concatenate possible id when multiple selection on name field separated using wild match

Shubu005 — Fri, 03 Aug 2018 03:35:51 GMT

Hello Vamseer,

Thank you for your help.

I will re framed the question again. Sorry for the trouble.

Thanks

Shubham