Regular statements within the Qlik Sense app script are used to load and transform data. This article will list the regular statements and their purpose. Click on the statement to see further information such as the syntax and an example.
Note that regular statements can span over any number of lines. They must always end with a ‘;’.
| Alias | An ‘alias’ statement is used to rename a field to a specified name each time it occurs in the load script. See more |
| Autonumber | The ‘autonumber’ statement creates a unique integer value for each unique value in a field. See more |
| Binary | The ‘binary’ statement is used to load data from another Qlik Sense app. See more |
| Comment | The ‘comment’ statement allows you to display metadata against fields. You can specify fields and the type of comment that should be noted on load. See more |
| Connect | The ‘connect’ statement opens a connection to a general database. See more |
| Declare | The ‘declare’ statement is for defining field definitions. Field definitions can be relations between fields or functions. See more |
| Derive | After using a ‘declare’ statement to define fields, the ‘derive’ statement is used to generate the fields. See more |
| Directory | ‘Directory’ is used to define the directory path where the load files should be taken from in subsequent ‘load’ statements. It is used before the ‘load’ statements. See more |
| Disconnect | The ‘disconnect’ statement terminates an open connection. See more |
| Drop field | This statement allows you to delete a field from a previously loaded table in memory. Note the statement drops the field in the data model, it doesn’t delete the field in the data source. See more |
| Drop table | This statement allows you to delete a previously loaded table in the data model. See more |
| Execute | This statement allows you to run other programs during the app reload. See more |
| Flushlog | This is a logging statement. It forces Qlik Sense to write the script buffer to the log file. See more |
| Force | This statement forces Qlik to read field names in a certain way: capitalised, uppercase, lowercase or mixed case. The ‘force’ statement must be before subsequent load statements. See more |
| Load | The ‘load’ statement is how data is loaded into Qlik. See more |
| Let | The ‘let’ statement is used to define variables. See more |
| Loosen table | This statement forces Qlik to disconnect fields within specific tables in the data model. It is the equivalent of loading each field in the table as a standalone disconnected table. See more |
| Map… using | The ‘map… using’ statement allows the mapping of multiple fields with a previously defined mapping table. See more |
| NullAsValue | The ‘NullAsValue’ statement converts NULL values in given fields to a specified value. See more |
| NullAsNull | The ‘NullAsNull’ statement turns off previously defined NULL conversions through the ‘NullAsValue’ statement. See more |
| Qualify | Using the ‘qualify’ statement gives the specified fields a prefix of the table name. See more |
| Rem | Using a ‘rem’ statement turns the script into a comment. Placing text between a ‘rem’ statement and a ‘;’ is equivalent to placing text between /**/. See more |
| Rename field | This statement renames specified fields. See more |
| Rename table | This statement renames specified tables. See more |
| Section | The ‘section’ statement defined whether subsequent ‘load’ or ‘select’ statements are data or access rights. See more |
| Select | The ‘select’ statement is used to pull data through standard SQL statements. See more |
| Set | The ‘set’ statements are used for defining variables. See more |
| Sleep | The ‘sleep’ statement pauses the script execution for a specified amount of time. See more |
| SQL | The ‘SQL’ statement allows you to send a command through a database connection. See more |
| SQLColumns | The ‘SQLColumns’ statement returns fields containing information about database columns. See more |
| SQLTables | The ‘SQLTables’ statement returns fields containing information about database tables. See more |
| SQLTypes | The ‘SQLTypes’ statement returns fields containing information about types of a data source. See more |
| Star | A star character can be used for representing all values. This can be set to a different character by using the statement ‘star’ which will affect all subsequent ‘load’ and ‘select’ statements. See more |
| Store | The ‘store’ statement creates a file that is stored in a specified location. See more |
| Tag | The ‘tag’ statement allows tagging of fields and tables with specified tags. See more |
| Trace | The ‘trace’ statement writes a string to the script execution log. Variables can also be written to the log using ‘trace’. See more |
| Unmap | The ‘unmap’ statement disables the previously used ‘map’ statement. The statement will be applicable to subsequently loaded fields only. See more |
| Unqualify | The ‘unqualify’ statement disables the previously used ‘qualify’ statement. See more |
| Untag | The ‘untag’ statement removes tags from specified fields or tables. See more |
