Skip to main content
Qlik Resources
Loading SearchUnify's search If you need assistance with your product, please contact Qlik Support.
Qlik Customer Portal
Loading SearchUnify's search If you need assistance with your product, please contact Qlik Support.
Qlik Customer Portal

Edit the data load script

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:

  • Click D in the toolbar to enter syntax help mode. In syntax help mode you can click on a syntax keyword (marked in blue and underlined) to access syntax help.

    Information noteYou cannot edit the script in syntax help mode.

  • Place the cursor inside or at the end of the keyword and press Ctrl+H.

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:

  • Select a keyword in the list by clicking on it or by pressing Enter.
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:

  • Press Ctrl+00

The test script code is inserted into the script.
Indenting code

You can indent the code to increase readability.

Do the following:

  1. Select one or several lines to change indentation.

  2. Click À to indent the text (increase indentation) or, clickà to outdent the text (decrease indentation).

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 F in the toolbar to open the Search and replace panel.

See: Searching in the load script

Selecting all code

You can select all code in the current script section.

Do the following:

  • Press Ctrl+A

All script code in the current section is selected.

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – please let us know!

Leave your feedback here