Early Access: The content on this website is provided for informational purposes only in connection with pre-General Availability Qlik Products. All content is subject to change and is provided without warranty.
The class function assigns the first parameter to a class interval.
The result is a dual value with a<=x<b as the textual value, where a and b are the upper and lower
limits of the bin, and the lower bound as numeric value.
An arbitrary string that can replace the 'x' in the result text.
offset
A number that can be used as offset from the default starting point of the classification. The default starting point is normally 0.
Examples:
Examples
Example
Result
class( var,10
) with var = 23
returns
'20<=x<30'
class( var,5,'value'
) with var = 23
returns
'20<= value <25'
class(
var,10,'x',5
) with var = 23
returns
'15<=x<25'
Example - Load script using class
Load script
In this example, we load a table containing name and age of people. We want to add a field that classifies each person according to an age group with a ten year interval. The original source table looks like the following.
Results
Name
Age
John
25
Karen
42
Yoshi
53
To add the age group classification field, you can add a preceding load statement using the class function.
Create a new tab in the data load editor, and then load the following data as an inline load. Create the table below in Qlik Sense to see the results.
LOAD *,
class(Age, 10, 'age') As Agegroup;
LOAD * INLINE
[ Age, Name
25, John
42, Karen
53, Yoshi];
A field contains values, loaded from a data source. At a basic level, a field corresponds to a column in a table. Fields are used to create dimensions and measures in visualizations.
A preceding load is a script construct that allows you to load from the following LOAD or SELECT statement without specifying that source. Preceding loads are often faster than resident loads.
