On each sheet I have different List box and mutli box.
Now I need to lock these list box and multi box in such a way that there selection only impacts the result on that specific sheet and not on all the sheets. How can this be done.
That's only possible if you use QV11. In QV11 you can define Alternate States on the General tab of the Document properties window. You can then assign the different states to the different sheets on the General tab of the sheet properties window. That way selection on one sheet (in one alternate state) will not influence selections on another sheet (in the other alternate state).
edit: Michael correctly points out below this can also be done with bookmarks. You could add the bookmark actions to the OnActivate and OnLeave sheet triggers. But these may not work in the ajax client. In that case you could hide the tabrow and use buttons or textboxes instead to navigate between sheets.
That's only possible if you use QV11. In QV11 you can define Alternate States on the General tab of the Document properties window. You can then assign the different states to the different sheets on the General tab of the sheet properties window. That way selection on one sheet (in one alternate state) will not influence selections on another sheet (in the other alternate state).
edit: Michael correctly points out below this can also be done with bookmarks. You could add the bookmark actions to the OnActivate and OnLeave sheet triggers. But these may not work in the ajax client. In that case you could hide the tabrow and use buttons or textboxes instead to navigate between sheets.
That's right. I would only add that you have to make sure all UI objects on a sheet (listboxes, multiboxes, charts, etc.) should have alternate state <inherited> -- in this case their state will be inherited from the sheet they are on. But this should be so by default.
Alternate State can be used, but it is not the only way. If you don't need to store selections when leaving a sheet, just use action "clear all". Otherwise, you can use bookmark actions.
I have a sheet and on that sheet I have - one listbox B (that has value 1.2 or 3) , one graph C and another copy of graph C called D.
Now when I select any value in listbox B (Say 1), values in graph C and graph D changes. Now when I select values in listbox B, only the graph D should change correspondingly but graph C should always point towards value 1 of listbox B.
In order way the filter should work only on Graph D and not on Graph C.
