Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

christian77
Valued Contributor

EXECUTING A MACRO IN IE

I'm trying to execute a macro when the document is being opened in Internet Explorer. It doesn't seem to work at all. Could somebody tell me how to do it?

Thanks.



8 Replies
Not applicable

EXECUTING A MACRO IN IE

Ensure the user has the latest IEPlugin installed and also that the security level allows the macro to run if it needs system access (press ctrl+shift+m whilst in the document in IEplugin to bring up the macro security options)

MVP
MVP

EXECUTING A MACRO IN IE

Hello Christian,

OnOpen and On PostReload macros will not execute when opening on server regardless the client you are using. Tell us something else about what you want to do so we can find a workaround for your issue.

Regards.

christian77
Valued Contributor

EXECUTING A MACRO IN IE

Hi:

What I want to do exactly is the next:

The QV doc. Is embedded in a aspx site. That page shows a list of articles. Once the user has selected an article, he can go to the QV doc and open it. The doc. must show only information about that article.

I need two things:

1º -- Pass the parameter of that article from the Internet page to QV

2º -- Read that Article_id and execute a macro, or a trigger that filters that field with that value.

Does anybody know how to do that.

Thaks again.

MVP
MVP

EXECUTING A MACRO IN IE

Hello,

You can use the url you have to launch to pass a parameter to a variable, then perform a selection using that variable:

http://server/folder/document.qvw?variable=value&variable2=value2


Haven't tested though, but since on open macros are not allowed, and you are passing parameters as values, check the use of "On Change" or "On Select" for variables.

Regards.

christian77
Valued Contributor

EXECUTING A MACRO IN IE

Hi: This is what i´m doing. The doc opens.

<iframe id="contenedor2v" name="contenedor2v" src=http://**.**.***.*/QvPlugin/opendoc.htm?document=EspacyoAnalisis.qvw&ARTICLE=AIG4980

frameborder="0" width="1024" height="768" runat="server" align="middle" visible ="true">

Now, how do I read that variable (ARTICLE) inside QV, in order to filter.

MVP
MVP

EXECUTING A MACRO IN IE

Hi,

Try the following in AJAX client

http://**.**.***.*/QvPlugin/opendoc.htm?document=EspacyoAnalisis.qvw&select=OID,AIG4980


Where OID is the object ID that contains the field ARTICLE. This should work.

christian77
Valued Contributor

EXECUTING A MACRO IN IE

Nope. It does not.

I´ve just installed QV 9 SR4, wrote the same line and it doesn´t do anything.

The objective is filtering only an article, but a different one everytime, based on the origin page.

christian77
Valued Contributor

EXECUTING A MACRO IN IE

It does not. QV 9 SR4...

Community Browser