Qlik AccessPoint Not Firing OnOpen Macro in QVW

[#1]

Hello,

I have built a qvw with QlikView Personal Edition 11.2 which is simply a report cover sheet that displays 2 or 3 data elements.  The data is retrieved via an ODBC call to a SQL Server schema with a straightforward SELECT statement.  When accessing the qvw directly, and not through an AccessPoint, a macro that was built (Settings -> Document Properties -> Triggers -> OnOpen -> ActiveDocument.Reload) to reload the data real-time fires and the data displays as expected.  Perfect.

This qvw was then published via an AccessPoint and is intended to be generated on demand from a third-party application.  This application essentially shells out to the qvw via a URL (i.e.:  Workflow.ShellAPI("http://qlikviewdev/QvAJAXZfc/AccessPoint.aspx?open=&id=QVS%40qlikviewdev%7COptiva%2FProjectCoverShee...")).  However, the macro does not run and the data is stale. Access rights have been granted on the Qlik Server.

Has anyone found a solution to this problem in Qlik?  We were initially using Crystal Reports but were trying to migrate away from it. Thanks in advance for any enlightenment.

-Chris-

[marcus_sommer]

You couldn't reload a document from the access point in this way - you will need to implement EDX:

Using EDX in QlikView 11 - basic example

and a lot more stuff could you find here:

https://community.qlik.com/search.jspa?q=EDX&type=document

- Marcus

[Peter_Cammaert]

To check what macro stuff is supported on the QlikView Server (and in which client), see Chapter 81 - Using Macros in QV Documents on the QV-Server in the QlikView Reference Manual.

[#4]

hi,

Macro will not support on the server or access point.