topic CLEAR SELECTIONS MACRO in QlikView

CLEAR SELECTIONS MACRO

Mon, 30 May 2011 10:16:29 GMT

Hi again community!!!

I have an easy cuestion for you. I am trying to create a a macro which funcionality must be clear all selections when I active one special sheet. The code I wrote was:

sub CLEAR_SLECTIONS

Activatedocument.clearselection

end sub

In other examples I saw, this functionality was asigned by a shorcut, but this time I only see macro options (sheet properties). Could anyone help me?

Thanks in advanced!!!! Fiber9906

CLEAR SELECTIONS MACRO

ali_hijazi — Mon, 30 May 2011 10:22:47 GMT

Right-Click on your button and click on properties

in the action tab add a new action under the Selection Action type and select the "clear all" action!

CLEAR SELECTIONS MACRO

Mon, 30 May 2011 10:39:29 GMT

I´m so sorry Ali, but I don´t understand you. On sheet properties, I select Macro tab and I assign CLEAR_SELECTIONS macro. My real problem is that script on edit module button is wrong.

I don´t see what you are trying to explain me...

Nevertheless, thanks for your soon reply!!

Fiber9906

CLEAR SELECTIONS MACRO

erichshiino — Mon, 30 May 2011 10:44:50 GMT

Try this:

Go to your sheet properties -> Triggers tab

On the box with the onActivateSheet (on the top), click on Add Actions (or Edit if you already have something there)

On the new window, click on Add

Action Type = External

Action = Run Macro

Click OK

Macro Name = CLEAR_SLECTIONS

On ali_hijazi suggestion , you don't need to write your macro, you only use the action already created

For this, you can:

Go to your sheet properties -> Triggers tab

On the box with the onActivateSheet (on the top), click on Add Actions (or Edit if you already have something there)

On the new window, click on Add

Action Type = Selection

Action = Clear All

Hope this helps,

Erich

CLEAR SELECTIONS MACRO

christian77 — Mon, 30 May 2011 10:49:37 GMT

CLEAR SELECTIONS MACRO

Mon, 30 May 2011 11:01:34 GMT

Erich, I still don´t have (or see) the options you are telling me. I attach what I am seeing...

My current version is 8.5.

Thanks, Fiber9906

CLEAR SELECTIONS MACRO

christian77 — Mon, 30 May 2011 11:28:25 GMT

Hi:

Read Eric's suggestion. Avoid macros. They work fine locally but not always via plug-in and/or via Ajax.

QV has a collection of actions already made. One of those actions is Unlock & Clear all selections.

What version of QV are you using?

If your QV does not have actions, do as you're doing.

I'd use better:

ActiveDocument.UnlockAll

ActiveDocument.ClearAll true

Ok.

CLEAR SELECTIONS MACRO

ali_hijazi — Mon, 30 May 2011 11:54:02 GMT

I was trying to tell you that you can accomplish this by putting a Button object which when you click clears all selections

Anyways Christian77 gave you the correct answer