Mastering Qlik Sense
by Ralf Becher, Karl Pover, Jason Michaelides, Dilyana Ivanova, David Alcobero, Martin Mahler, Juan Ignacio Vitantonio
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 ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access