Counter Functions
Counter functions count records within a table to return results. Some do not require any input values at all. This article will cover the basic principles of working with counter…
8 mins read
December 18, 2022
Conditional Functions
This article covers the basics of working with conditional functions in the data load editor, including deciphering the function syntax and combining conditional functions with other functions.
15 mins read
December 18, 2022
Aggregation Functions
Aggregation functions group multi-row data into a single row based on some grouping. The functions are calculated by looping through the table rows and working out each group's result. This…
18 mins read
December 18, 2022
Script Functions
Script functions within the Qlik Sense app script are used to transform and aggregate data. This article will list the types of functions available and their purpose. Click on the…
21 mins read
December 10, 2022
The ‘Untag’ Regular Statement
This article will cover the syntax of the 'Untag' regular script statement. This statement is used to remove specific tags from fields or tables. Statement syntax Field | Fields |…
3 mins read
December 10, 2022
The ‘Unqualify’ Regular Statement
This article will cover the syntax of the 'Unqualify' regular script statement. This statement is used to remove the qualify statement previously used from fields. This is useful for leaving…
2 mins read
December 7, 2022
The ‘Unmap’ Regular Statement
This article will cover the syntax of the 'Unmap' regular script statement. This statement is used to remove previously specified field mapping for subsequent loads. Statement syntax FieldlistA comma separated…
2 mins read
December 7, 2022
The ‘Trace’ Regular Statement
This article will cover the syntax of the 'Trace' regular script statement. This statement is used to write a comment to the execution log window and the execution script. This…
2 mins read
December 7, 2022
The ‘Tag’ Regular Statement
This article will cover the syntax of the 'Tag' regular script statement. This statement is used to add tags to fields and tables. Tags are a way for a developer…
3 mins read
December 6, 2022
The ‘Store’ Regular Statement
This article will cover the syntax of the 'Store' regular script statement. This statement is used to store a QVD, CSV or TEXT file in a specified location. Statement syntax…
3 mins read
December 6, 2022