topic Re: Assign value to Multibox Items in QlikView

Assign value to Multibox Items

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

Hello ,

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

regards

Re: Assign value to Multibox Items

qolkaram — Wed, 14 Dec 2016 07:15:58 GMT

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

Re: Assign value to Multibox Items

qolkaram — Thu, 15 Dec 2016 05:36:25 GMT

would you mind Help me to solve my issue?

Re: Assign value to Multibox Items

jonathandienst — Thu, 15 Dec 2016 05:52:38 GMT

What do you mean by "assign"?

Re: Assign value to Multibox Items

ganeshsvm — Thu, 15 Dec 2016 06:22:56 GMT

Hi,

Post a sample data and elaborate on your requirement.

Re: Assign value to Multibox Items

avinashelite — Thu, 15 Dec 2016 06:24:37 GMT

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

Re: Assign value to Multibox Items

qolkaram — Thu, 15 Dec 2016 06:30:45 GMT

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.

Re: Assign value to Multibox Items

avinashelite — Thu, 15 Dec 2016 06:50:59 GMT

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))

Re: Assign value to Multibox Items

qolkaram — Thu, 15 Dec 2016 07:58:06 GMT

thanks but where i should add the expression ?

Re: Assign value to Multibox Items

qolkaram — Thu, 15 Dec 2016 09:32:53 GMT

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

Re: Assign value to Multibox Items

ganeshsvm — Thu, 15 Dec 2016 09:54:53 GMT

add it inside the search substring textbox as,

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

Re: Assign value to Multibox Items

qolkaram — Thu, 15 Dec 2016 11:36:41 GMT

can you please check attached file ,i have done the same but it is not working.

Re: Assign value to Multibox Items

avinashelite — Thu, 15 Dec 2016 12:52:34 GMT

ass it in the search string place

Re: Assign value to Multibox Items

ganeshsvm — Thu, 15 Dec 2016 12:58:45 GMT

Sorry, I have QV personal edition, so cannot open your doc.

Image/sample data or the script will do it.

Re: Assign value to Multibox Items

kuba_michalik — Thu, 15 Dec 2016 13:25:10 GMT

First, you are using alternate states. You need to specify which alternate state the action applies to, it's next to the Delete button in action settings (presumably, Ad Hoc state).

Second, I don't think this search string will work, because one does not simply put quotes in search strings (unless one explicitly wishes to search for quotes). Use this formula instead:

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

This will return current selections (without quotes) separated by | and wrapped in parentheses, which is the search string syntax for "or".

Re: Assign value to Multibox Items

MK9885 — Thu, 15 Dec 2016 15:23:16 GMT

It is not working cus there is no link between tables/fields in your data model. That might be the issue.

Re: Assign value to Multibox Items

qolkaram — Fri, 16 Dec 2016 00:08:23 GMT

thanks ,the expression is working at least when one item is selected but what should i do for muti selection scenario?

Re: Assign value to Multibox Items

ganeshsvm — Fri, 16 Dec 2016 08:04:47 GMT

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

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

Re: Assign value to Multibox Items

Fri, 16 Dec 2016 09:28:41 GMT

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

Re: Assign value to Multibox Items

kuba_michalik — Fri, 16 Dec 2016 11:50:52 GMT

Nothing. This will work for multiple selections as well, try it. Only issue is that GetFieldSelections function will return results like "7 of 22 selected" if there are too many values selected. That can be worked around with third argument, which specifies after how many values it should switch to the shortened form:

=if(GetSelectedCount(Company)>0,'('&GetFieldSelections(Company,'|',FieldValueCount('Company'))&')')

(the selection limit is set to be equal to number of values in the field)

Alternatively, you can use the version with Concat as suggested by Ganesh.