topic Undo Select in Field onLeaveSheet in QlikView

Undo Select in Field onLeaveSheet

Tue, 03 Apr 2012 20:06:29 GMT

Hi All,

I have a sheet that displays data in a table box only for a specific value in a field. This is accomplished by placing a 'Select in Field' Action for the OnActivateSheet event. Works great! However, it will undo selections for other fields in the application in order to fullfill the action. I want to be able to go back and have those values re-selected OnLeaveSheet. Kind of a 'restore state to previous conditions' action.

Any ideas?

Undo Select in Field onLeaveSheet

Tue, 03 Apr 2012 21:24:49 GMT

I have been attempting to use bookmarks by creating one as I go into the tab and then applying that bookmark on leaving the tab. Has anyone used this technique successfully? Other ways?

Undo Select in Field onLeaveSheet

Tue, 03 Apr 2012 22:00:16 GMT

Here is my current dilemma:

Sheet Properties > Triggers > OnActivateSheet > Actions

Replace Bookmark (Current)

Select in Field

Lock Field

Sheet Properties > Triggers > OnActivateSheet > Actions

Apply Bookmark (Current)

Unlock Field

Without the Lock Field, Clear would blow up the table box.

But the field doesn't unlock when I leave the sheet. The bookmark step will only work if the bookmark exists. If I make a new one each time, well,.....

Does someone have a simple example of how this might work?

Background: the system we use has a field in a table that does double duty. It allows the id of the user OR the name of a group. The userid is used to identify users in the system and in my application. And my section access is based on it. So the users of the system don't have access to the 'users' with the name of a group. I just want to display the objects in the system with the group name. I've tried a number of things, including adding the group name as a 'user' and adding it to the section access. Nothing so far. I seem to be right around the edges of a solution, but nothing that's ready for prime time.