Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
Thanks!
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
Try the search string (Line|Subtotal). Some more details are available here.
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