topic Clear selection when changing sheets in QlikView

Clear selection when changing sheets

Wed, 28 Jul 2010 12:08:25 GMT

Hi,
I want to clear a Selector when the user moves from a certain sheet to another certain sheet. The problem is that it does not concern all changes between sheets. Example: when the user moves from sheet A to sheet B the field should not be cleaned but when the user moves from sheet B to sheet C the filed should be cleaned.

Does anyone have any ides?

Clear selection when changing sheets

Wed, 28 Jul 2010 12:15:49 GMT

Have a look at the Triggers tab on the Sheet properties, in particular the 'OnLeaveSheet' even.

Regards,

Gordon

Clear selection when changing sheets

jonathandienst — Wed, 28 Jul 2010 12:21:22 GMT

You can add a selection action to the OnActivate sheet and/or OnLeave sheet events. You can use these triggers to clear fields or set default selections. The only issue is that this needs to be done for each sheet.

Jonathan

Clear selection when changing sheets

Wed, 28 Jul 2010 12:59:06 GMT

If I use the OnActivate sheet I need to know which the previos sheet was, how do I get that information?

Clear selection when changing sheets

kji — Wed, 28 Jul 2010 13:18:10 GMT

You could define a variable LastSheet that you set in OnDeactivate Sheet, and check it in OnActivate.

Clear selection when changing sheets

Wed, 28 Jul 2010 16:32:58 GMT

I tried this in OnDeactivate Sheet:

sub e

xitSheet
set LastSheet = ActiveDocument.ActiveSheet.GetProperties.Name
end sub

but it does not turn out well. When I change sheets, it stops in the macro with this message:
Object required: '[string: "Agent"]'