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];
Some of the examples in this topic use inline loads. For more information, see Inline loads.
Results
Results
Name
Age
Agegroup
John
25
20 <= age < 30
Karen
42
40 <= age < 50
Yoshi
53
50 <= age < 60
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 – let us know how we can improve!
