Introduction

QlikView has a lot of great functions that enable us to manipulate data, make selections, interact with the layout, or export data to a file. These functions can be accessed from the Actions option of buttons, gauge charts, text objects, or line/arrow objects.

However, QlikView also has a rich API that allows us to use a macro language—either VBScript or JavaScript—to perform actions. In this chapter, we are going to explore using macros to perform some advanced tasks that are not available otherwise. We will also look at using VBScript to create functions that can be used in charts.

Documentation on the QlikView API is installed by default into C:\ProgramData\QlikTech\QlikView Documentation\Automation\QlikView Automation Reference.pdf. There is also a very useful APIGuide.qvw file in the same folder that allows you to search the API and view sample code.