list boxes multiple selections

[#1]

Hello,

I have a problem to set a fixed selection in two list boxes at the same time.

The problem is this:

I have two list boxes A and B. List box A containes Conso, Unconso.

List box B containes Total, Subtotal, line.

I want to set a fixed selection when Conso is selected, that automatically Total is also selected.

Does anybody know how to do this?

Gert

[#2 · Accepted solution]

Hi,

You need to use Field Event Trigger and define OnSelect Trigger.

OnSelect event of first field define the event to "Select in field" in second field.

Find attached a sample file.

Hope it helps.

Regards

Amar Nath

[#3]

Thanks!

[rob_greene]

Hi Amar, that was realy helpful,

Do you have the syntax if you want to select Line AND Subtotal with the selection of conso ?

In my app I want to select multiple values in the dimension.

I have tried ('Line','Subtotal') and ('Line'|'Subtotal') and various other separators, but with no luck.

Many thanks

Rob

[nagaiank]

Try the search string (Line|Subtotal). Some more details are available here.

[rob_greene]

Thanks krishnamoorthy, you were right. Thank you for pointing me in the right direction.

This is the syntax that worked for me in the end. I had to put the desired values in brackets within single quotes.
I put an IF statement in too because I needed it in my app.  Thought it would be useful.

=IF(GetFieldSelections(F1)='Conso','(Line|Subtotal)')

All the best

Rob