The QIX internal database

The QIX internal database uses symbol tables and data tables. These two types of tables get created after the script engine executes the script. The script execution is sequential; this means that it is executed from left to right and from top to bottom.

Allow me first to describe how symbol tables are created in memory and what these tables contain.

The script engine is responsible for executing our Qlik Sense script. Whenever the script engine executes a LOAD or a SQL Select statement, it will bring into memory all the rows and columns in the data source, unless otherwise specified in the syntax. The data source can be anything from an Excel file to a table in a database.

The QIX internal database builds a separate ...

Get Mastering Qlik Sense now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.