Always one specific value is selected in the list box along with the other selections

[#1]

How can I have one value always selected in the list box.

In the below tables, when I make any selection in the Region, I want APAC to be selected along with my selections. Similarly when I make any selection, in Market Sector, I should have the FI selected along with the selections I want.  When I don't select anything from the Region or Market Sector, then it should not select anything. Thanks for the help.

Region
North America
APAC
EMEA
LATAM

Market Sector
FI
ABC
SF
Copr

[#2]

Did you try solve it by  "Load * inline" ?

e.g.

APAC , North America

APAC , EMEA

APAC , LATAM

[#3]

I can not load it like that. It a lot of data and users will be confused. Is there any way I can use a trigger to have those values selected on any change on those fields?

[sunny_talwar]

So you are trying to select APAC regardless of what you have selected in your region listbox?

[#5]

Exactly.

Thanks

[sunny_talwar]

Have a look at the attached qvw and see if this is what you want:

Select in Field Action

Search String: ='(APAC|' & If(GetSelectedCount(Region) >0, Concat(Region, '|') & ')', ')')

HTH

Best,

Sunny

[chaper]

Try in document properties Add a trigger OnAnySelect and select Action Select in Field and use Field=Region and value='APAC'.

[sunny_talwar]

It is somehow isn't working with North America, may be because of the space between the two words North and America. I am trying to figure out what the issue is

[#9]

You are right. It is working for all except for North America. Thanks for the quick response.

[#10]

Then it will select only APAC regardless of what I select.