{"id":38545,"date":"2018-11-18T13:30:16","date_gmt":"2018-11-18T08:00:16","guid":{"rendered":"https:\/\/data-flair.training\/blogs\/?p=38545"},"modified":"2021-12-07T11:20:10","modified_gmt":"2021-12-07T05:50:10","slug":"qlikview-automation-macro","status":"publish","type":"post","link":"https:\/\/data-flair.training\/blogs\/qlikview-automation-macro\/","title":{"rendered":"QlikView Automation – How to Create QlikView Macro?"},"content":{"rendered":"

In our last session, we discuss\u00a0Dollar Sign Expansions<\/strong>. Here, we will learn about QlikView Automation and how to create QlikView Macro. Moreover, we will discuss how to use macros in QlikView.<\/p>\n

Macros make a crucial part of any software. You must be familiar with Macros from MS Word and MS Excel as they use significantly in such software. In QlikView too, utilizes macros and automate tasks.<\/p>\n

So, let’s start QlikView Automation and Macros Tutorial.<\/p>\n

QlikView Automation and Macro<\/h3>\n

Automation is a full-fledged feature in QlikView. QlikView documents<\/strong> and applications can access and control by external programs or internal macros (residing in QlikView).<\/span><\/span><\/p>\n

These are the two main services that let the users experience the QlikView automation interface. It is not an additional installation that you need to make in order to avail the automation services.<\/span><\/span><\/p>\n

QlikView Automation interface is an integral part of QlikView\u2019s design, using it is just a matter of choice of the way out of many that you would want to go with.<\/span><\/span><\/p>\n

Primarily, there are two modes of automation in QlikView,<\/span><\/span><\/p>\n

i. External Control Automation<\/span><\/span><\/h4>\n

External software or stand-alone programmes can access QlikView objects or documents via automation and macros in QlikView. <\/span><\/span><\/p>\n

Although, one this is to note here is that all such external programmes willing to take control of QlikView via automation must create with a Visual Basic (VB) script or C++ script because only the codes written in these, supports QlikView macro and automation.<\/span><\/span><\/p>\n

ii. Internal Control Automation<\/span><\/span><\/h4>\n

Another way is by invoking automation services within QlikView applications or documents. Thus, internal control. It is done with the help of an Internal Macro Interpreter as it is often addressed so. <\/span><\/span><\/p>\n

QlikView objects can be called through running macros written in VBscripts or JScripts internally during script execution. Such QlikView automation (running a macro) can apply at various layers and items in QlikView.<\/span><\/span><\/p>\n

a. Document Level<\/h5>\n

QlikView Macro can execute at a document level with various document events mention below.<\/span><\/span><\/p>\n