topic problem with macro/trigger/selection in QlikView

problem with macro/trigger/selection

fabio — Tue, 13 Jan 2015 09:59:29 GMT

Hi!

I have a button (myButton) with a action (select in field). It works fine.

I need to press this button at any selection in auto.

I created a new trigger in the "document event trigger" of type "OnAnySelection" that launches this macro:

Set myButton = ActiveDocument.GetSheetObject("myButton")

MyButton.Press

Now, when I make any selection, i have to make the selection TWICE!!

the first selection the sheet does not update! why?

help me please 😄

alexandros17 — Tue, 13 Jan 2015 10:04:53 GMT

Could you sent your document or a small version reproducing the error?

jzimolong — Tue, 13 Jan 2015 12:06:28 GMT

Not sure if attached is exactly what you are looking for, but it triggers macro on any selection in field "Auto".

Anonymous — Tue, 13 Jan 2015 13:01:13 GMT

Hello,

I tried to make selections in your application and immediatly Auto is selected to Honda (I didn't need to clik twice).

I also tried to set your trigger in the "document event trigger" of type "OnAnySelection" (as you said in your first post) and it works.

I use QV 11 SR1...

Anyway, I read that macros are not always "safe"... it can be that sometimes they don't work properly.