topic Re: Macro not being fired in QlikView

Macro not being fired

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hello,

I have 3 sheets (SH1, SH2, SH3) in a QV document. In SH1, I have a textbox (TB1) which

does this Actions -> Activate Sheet (SH3). On SH3, I have a trigger that does this

Triggers -> OnActivateSheet -> Run Macro -> ResetValues.

The problem I am having is that the macro (sub routine) called ResetValues is not being

fired. If I just open this QV document and click on tab3 which is SH3, this macro

gets executed.

Am I not doing this right? How do I fix this?

Thanks

Re: Macro not being fired

trdandamudi — Mon, 04 Dec 2017 19:33:32 GMT

Is it possible to attach a small sample ?

Re: Macro not being fired

Anonymous — Mon, 04 Dec 2017 19:36:25 GMT

Sorry, no. It has company data.

Re: Macro not being fired

trdandamudi — Mon, 04 Dec 2017 19:40:21 GMT

Understood... Can you share the screen shot of the Actions ?

Re: Macro not being fired

Anonymous — Mon, 04 Dec 2017 19:50:23 GMT

First screenshot is my SH1. It calls "SH08" which invokes a macro called "ResetDetailViewSel". This

macro is not being fired through these series of events. If I click directly on the tab for SH08, it works.

Re: Macro not being fired

MK9885 — Mon, 04 Dec 2017 20:01:02 GMT

Maybe try this?

In SH1

First Action:- Button to activate the SH3

Second Action:- Run Macro

Re: Macro not being fired

Anonymous — Mon, 04 Dec 2017 20:03:24 GMT

So you want me to run the macro from SH1?

Re: Macro not being fired

MK9885 — Mon, 04 Dec 2017 20:05:13 GMT

Yes, try that?

I tested on my Macro but the macro which I have doesn't just get activated unless we click on it.

Is Macro specific for single sheet or all across dashboard?

Re: Macro not being fired

Anonymous — Mon, 04 Dec 2017 20:30:16 GMT

The problem seems to occur only when the QV app is being executed from AccessPoint. In QV Designer

on the Windows desktop, it seems to be working fine. Why?

Re: Macro not being fired

MK9885 — Mon, 04 Dec 2017 20:36:25 GMT

Check the reply from Peter

Qlikview Macro not working in Access Point

As he says, the VB Macros won't work on Ajax but may work on IE Plugin.

I guess you can change the plugin from QMC.

I don't know what effect it would happen if you change from Ajax to IE...

But many of the Macros fail to work in Access Point

Re: Macro not being fired

trdandamudi — Mon, 04 Dec 2017 20:42:57 GMT

Macros will not work in Ajax, You need to use IE and it will work.

Re: Macro not being fired

Anonymous — Mon, 04 Dec 2017 20:43:28 GMT

Can you explain what Ajax means or difference between Ajax and IE?

Re: Macro not being fired

MK9885 — Mon, 04 Dec 2017 20:46:38 GMT

How to change Ajax to IE Plug-in

Check above link....you can change it from QMC, if you've access to QMC.

Re: Macro not being fired

Anonymous — Tue, 05 Dec 2017 15:47:28 GMT

OK, I did some reading on AJAX vs. IE Plugin. I still don't understand why the macro runs if I click on the tab

directly but not from another sheet where it does the ActivateSheet.

Re: Macro not being fired

trdandamudi — Tue, 05 Dec 2017 16:18:07 GMT

Are you accessing this dashboard from Access point ? If you are, and then you are saying when you click on the tab it is working but not from another sheet ?

Which plugin are you using IE or AJAX ?