# Regular statements

Regular statements are typically used for manipulating data in one way or another. These statements may be written over any number of lines in the script and must always be terminated by a semicolon, ";".

All script keywords can be typed with any combination of lower case and upper case characters. Field and variable names used in the statements are however case sensitive.

Use the drop-down on each function to see a brief description and the syntax of each function. Click the function name in the syntax description for further details.

[](https://help.qlik.com/en-US/sense/Subsystems/Hub/Content/Sense_Hub/ChartLevelScripting/modifier-regular-statements.htm)

#### LOAD

In a chart modifying context, the LOAD statement loads additional data to the hypercube from data defined in the script, or from a previously loaded table. It is also possible to load data from analytic connections.

Information noteThe LOAD statement must have either Replace or Add prefix, or it will be rejected.

Add | Replace [**Load**](https://help.qlik.com/en-US/sense/May2025/Subsystems/Hub/Content/Sense_Hub/ChartLevelScripting/RegularStatements/Load.htm) [ distinct ] fieldlist

(

inline data [ format-spec ] |

resident table-label

) | extension pluginname.functionname([script] tabledescription)]

[ where criterion | while criterion ]

[ group by groupbyfieldlist ]

[order by orderbyfieldlist ]

[](https://help.qlik.com/en-US/sense/Subsystems/Hub/Content/Sense_Hub/ChartLevelScripting/modifier-regular-statements.htm)

#### Let

The let statement is a complement to the set statement, used for defining script variables. The let statement, in opposition to the set statement, evaluates the expression on the right side of the ' =' at script run time before it is assigned to the variable.

[**Let**](https://help.qlik.com/en-US/sense/May2025/Subsystems/Hub/Content/Sense_Hub/ChartLevelScripting/RegularStatements/Let.htm) variablename=expression

[](https://help.qlik.com/en-US/sense/Subsystems/Hub/Content/Sense_Hub/ChartLevelScripting/modifier-regular-statements.htm)

#### Set

The set statement is used for defining script variables. These can be used for substituting strings, paths, drives, and so on.

[**Set**](https://help.qlik.com/en-US/sense/May2025/Subsystems/Hub/Content/Sense_Hub/ChartLevelScripting/RegularStatements/Set.htm) variablename=string

[](https://help.qlik.com/en-US/sense/Subsystems/Hub/Content/Sense_Hub/ChartLevelScripting/modifier-regular-statements.htm)

#### Put

The Put statement is used to set some numeric value in the hypercube.

[](https://help.qlik.com/en-US/sense/Subsystems/Hub/Content/Sense_Hub/ChartLevelScripting/modifier-regular-statements.htm)

#### HCValue

The HCValue statement is used to retrieve values in a row of a specified column.