You write the script in the text editor of the data load editor. Here you can make manual changes to the LOAD/SELECT statements you have generated with the data selection pop-ups, and type new script.
The script, which must be written using the Qlik Sense script syntax, is color coded to make it easy to distinguish the different elements. Comments are highlighted in green, whereas Qlik Sense syntax keywords are highlighted in blue. Each script line is numbered.
There are a number of functions available in the editor to assist you in developing the load script:
| Detailed syntax help |
There are two ways to access detailed syntax help for a Qlik Sense syntax keyword:
|
| Auto-complete |
If you start to type a Qlik Sense script keyword, you get an auto-complete list of matching keywords to select from. The list is narrowed down as you continue to type. For example, type month. Do the following:
|
| Tooltips | When you type an open parenthesis after a Qlik Sense script function, a tooltip displays the syntax of the function, including parameters, return value types and additional statements. |
| Prepared test script |
You can insert a prepared test script that will load a set of inline data fields. You can use this to quickly create a data set for test purposes. Do the following:
The test script code is inserted into the script. |
| Indenting code |
You can indent the code to increase readability. Do the following:
Tip note
You can also use keyboard shortcuts: Tab (indent) Shift+Tab (outdent) |
| Search and replace |
You can search and replace text throughout script sections. Click in the toolbar to open the Search and replace panel. See also: Searching in the load script |
| Selecting all code |
You can select all code in the current script section. Do the following:
All script code in the current section is selected. |