Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
can anyone tell me how i can pass a selection from 1 list box on a sheet (inherited state) to another list box on another sheet (in state2).
I have attached an example.
in the example i have 2 alternate states, ignore State1 as this is used on another part of the qvw.
Thanks
Hi all,
for anyone else who needs to do this i have managed to get it working using an on activate sheet trigger.
see attached sample
Use a Macro to Select in Field using a Concatenation from one state and apply the select in field to the other STATE.
create one alternate state.
documents and settings->alternate state->New state
for what ever objects we want we can give the alternate state.
Object properties->General->Alternate state
So of 2 objects are having one single alternate state, either they may be there in different sheets the selections will pass only to those 2 objects
hi, i dont want to use a macro as i believe this can be done using triggers.
also, both objects need to stay in their current states (on sheet 1 inherited, on sheet 2 state2) this is because if i place them both in the same state then other objects on those sheets wont respond to them.
I need all objects on sheet 1 to continue responding to the selections made in the list box and all objects on sheet 2 to respond to the selections from the list box on sheet 2
Does that make more sense?
Hi so you are looking for
Sheet 1 and one object from sheet 2 need to modify based on the selections in sheet 1
Sheet 1:
entire sheet->Alternate state->state1
sheet 2:
Only one object->Alternate state->state1
No, sheet 1 stays as default state (all objects).
Sheet 2 is state 2 (all objects)
but i want to carry selections from the list box on sheet 1 over to the same list box on sheet 2.
if i set the 2 list boxes up in their own state then the other objects on the same sheets will not respond to the selections.
i just want to be able to set a trigger so when i move to sheet 2 i carry the selections over from the list box on sheet 1
Sorry I can't get you, by default the selections will pass to all sheets right.?
more over if we assign state1 alternate state to sheet 1, so what ever selections we done in sheet 1 list box will reflect in only in sheet1 and if we assign staate 1 alternate state in sheet 2 list box then this list box also the selections will pass.
You can just achieve this by using set analysis in the charts that you want to react to both
Using
Sum({MyFirstState <Year=MySecondState::Year>} SALES)
hi, the selections will only pass if they are in the same state.
sheet 2 will be in a different state.
I want sheet 1 to be in the default state
Sheet 2 to be in state 2
so no selections will pass across in this setup.
so i want to override that by passing the selections from a single list box on sheet 1 (that is in the default state) to the same list box on sheet 2 (that is in state 2)
i think i need to use a getfieldselections and a concat maybe into a variable then use a select in field trigger on sheet 2 to pass the variable contents to the list box in state 2. but i dont know the syntax to use.
Hi Steve,
Thanks for your reply. but that means changing every expression in every chart on that sheet.
surely there is an easier way?