Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
qolkaram
Contributor III
Contributor III

Assign value to Multibox Items

Hello ,

i want to assign value to multibox items based on another multibox selected items .can any body help me on this ?

regards

1 Solution

Accepted Solutions
ganeshsvm
Creator II
Creator II

You can try this code snippet also, for multiple or single selection.

=if(GetSelectedCount(Company) >0,'(' & Concat(Distinct Company, '|') & ')')

View solution in original post

20 Replies
qolkaram
Contributor III
Contributor III
Author

Just to add on point there is no relation between fields in two multibox and i have to scan all items from first multibox to identify selected values and assign them to another multibox items

qolkaram
Contributor III
Contributor III
Author

would you mind Help me to solve my issue?

jonathandienst
Partner - Champion III
Partner - Champion III

What do you mean by "assign"?

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
ganeshsvm
Creator II
Creator II

Hi,

Post a sample data and elaborate on your requirement.

avinashelite

Please share the sample data and explain your requirement so that it will be easier for us to understand

qolkaram
Contributor III
Contributor III
Author

suppose in first multi box there is a field name "Company"  and in second multi box there is a field name sub_con_company  . now for example if user select "PCT"  for company I want "PCT" automatically get selected for sub_con_company  in second muti box .  just to remind there is no relation between two multi box.

Capture.JPG

avinashelite

Try with triggers .

Go to document properties >Triggers >

select the field 1 from the list > add on event trigger >Add action>Field selection >select second fields name where you want the selection > add this expression

if(getselectedcount(Company)>0,chr(39)&GetFieldSelections(Company,chr(39)&','&chr(39))&chr(39))

qolkaram
Contributor III
Contributor III
Author

thanks but where i should add the expression ?

Capture.JPG

qolkaram
Contributor III
Contributor III
Author

hey avinash , is the image clear to you , did u get my question ?