topic Macro to clear some selections ? in QlikView

Macro to clear some selections ?

Tue, 27 Oct 2009 20:09:19 GMT

Hi everybody !!!

I am here because I am trying to do a Macro to clear selections in a field if another is selected.

For example: I have the Field1 and the Field2.

If I have selected the Field1, I want to Clear the Field2 and vice versa.

I would appreciate your help.

Bye.

Macro to clear some selections ?

Tue, 27 Oct 2009 20:21:11 GMT

Simple macros for this one.

Macro 1:

Sub ClearField1

ActiveDocument.Fields("Field1").Clear

End Sub

Sub ClearField2

ActiveDocument.Fields("Field2").Clear

End Sub

So, you should trigger each macro when one of those fields changes, if Field2 changes then trigger Macro ClearField1 and vice-versa. Macro triggers can be found on the document settings, macros tab.

Good luck,

Macro to clear some selections ?

Tue, 27 Oct 2009 20:44:40 GMT

It Worked !!!

Many Thanks.