Qlik Scripting is a part of the Data Load Editor, it is a very powerful side of Qlik as it allows us to handle ETL style processes before our data hits the app.
It is in our best interest to do any data-intensive calculations within our Scripting and not on the front-end of the app as the user has to wait for a front-end calculation to process.
See Qlik Scripting Errors for help with errors when scripting.
Scripting
Basic Tips
Comments and Help
//is how you write a comment- When clicking the Question Mark Icon, every word will turn into a hyperlink, leading you straight to documentation about the given keyword
Tables
- The
&operator can be used to concatenate columns together - Sections can be labeled by the use of a
: - Reserved names within scripts are not case-sensitive, but any item loading from a table is
- When loading two data sources inside of a script, if they have the same exact schema, they will be loaded into the first table that has that structure. However, this is an implicit action, it happens inside of Qlik, and not through our explicit coding
Script Control Statements
Qlik Loops
Prefixes
A Script Prefix is a word that is added before an existing method within a Qlik Script to modify the behavior. An example is INNER JOIN, this could be placed before a SQL call to join to another table on the associated key.
Some script prefixes examples:
- Join
- Concatenate
- Crosstable
- IntervalMatch
- Mapping