I have created two sheets, In which second sheet contains tables to show only information without any filters. I dont want second sheet to get affected by the first sheet selections.
I want first sheet selections to be same when I switch from second sheet to first sheet or vice-versa
PS: I used Clear selections trigger but it didn't worked. All the listboxes in 1st sheet are checked with 'ALways one selcted value' option
If you use QV11 then you can define alternate states on the General tab of the document properties window. You can then assign the different alternate states to each of your sheets on the General tab of the sheet properties window. Selections on one sheet then won't influence selections on the other sheer.
Create a bookmark per sheet. Then set the bookmark with an action on the OnLeaveSheet trigger to save the current selections and reapply the bookmark with the OnActivateSheet trigger to retrieve the selections previously active on the sheet. You'll need to do this for each sheet. There's no other way that I know of that works with QV10.
On my sheet1, on leave page action i applied create bookmark and on acctivate page I applied bookmark. On the sheet 2 , on activate page I applied clear all selections trigger .
Here whenever i switch form sheet 2 to sheet 1 It shows my first time bookmarked selections. If I change the selections when I am switching back it shows the first time bookmarked selections.
