Skip to main content Skip to complementary content

How Automation can control QlikView / QlikView OCX

External control of QlikView /QlikView OCX

QlikView objects are accessible by means of Automation from external programs,

E.g. programs written in Visual Basic or C++ supporting Automation.

Such code can be used to control QlikView from other applications or from stand-alone programs.

Stand-alone executable files can be invoked from a QlikView document by means of launch buttons.

QlikView events

A number of predefined events may be used to trigger a macro in the QlikView/QlikView OCX internal VBScript module. All these events also trigger the OnMacro event in QlikView OCX, which can be picked up and acted upon by the host application.

The events are:

Application events
Event ID Event Description
1 A macro can be run after opening a QlikView document.
2 A macro can be run after script re-execution.
3 A macro can be run after the Reduce Data command.
4 A macro can be run after a selection in any field in the application.
Sheet events
Event ID Event Description
5 A macro can be run after a sheet is activated.
6 A macro can be run when a sheet is deactivated.
Sheet object events
Event ID Event Description
7 A macro can be run after a sheet object is activated.
8 A macro can be run when a sheet object is deactivated.
Button events
Event ID Event Description
9 A button sheet object can be linked to a macro.
Field events
Event ID Event Description
10 A macro can be run after a selection has been made in a specified field.
11 A macro can be run when a selection is made in any field logically associated with a specified field.
12 A macro can be run after selections have been locked in a specified field.
13 A macro can be run after selections have been locked in a specified field.
Variable events
Event ID Event Description
14 A macro can be run after a value has been entered in a specified variable.
15 A macro can be run when the value of a specified variable containing a formula has been changed due to a change in the formula value.

In addition, QlikView OCX 7.52 and later versions have the general OnDataChanged event, which is a general notification event signaling that data or selections have changed in the loaded QlikView document.

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!

Join the Analytics Modernization Program

Remove banner from view

Modernize without compromising your valuable QlikView apps with the Analytics Modernization Program. Click here for more information or reach out: ampquestions@qlik.com