# New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Customers, Partners & Luminaries only: You're invited to a Data Analytics Roadmap session. Read More
cancel
Showing results for
Did you mean:
Highlighted
Champion

## Offset in Class()

Hello Qlikers,

Can somebody help me to find out how Offset works in Class() Function??

=Class(10,5,'X',3)

How this 3 will be used in calculation while calculating expression?

1 Solution

Accepted Solutions
Highlighted
MVP

If offset, the first range will end with that offset integer...

SIMPLE !

17 Replies
Highlighted
Champion III

hi,

example

class( var,10,'x',5 ) with var = 23 returns '15<=x<25

Highlighted
Master II

Hi Balraj,

In class function 0 is normally the default starting point of the classification. By setting an offset you can change the default starting point.

Regards

KC

Best Regards,
KC
Highlighted
Champion

Dear,

I already know this, I am asking how offset 5 is getting calculated here?

Highlighted
MVP

Seems to determine where you class starts from. Look at this example:

Table:

Class(Age, 5, 'X', 3) as Class1,

Class(Age, 5, 'X') as Class2;

AutoGenerate 1000;

Output:

Highlighted
Champion

Jyothish,

Thats fine.  But I tried lot with Class() calculation, here are some example:

=Class(30,4,'X',9) gives 29<=X<33

=Class(30,4,'X',8) gives 28<=X<32

=Class(30,4,'X') gives 28<=X<32

How this offset values are being used here, like?

30-9+4   or 30+9-4 like this?

Highlighted
Champion

Sunny, thanks for sharing this...My concern is how this offset value change the min and max value?

Highlighted
MVP

Change the min and max value? of the underlying field?

Highlighted
Champion

mean to say,

For age 1, with offset how it is giving -2<=x<3

Highlighted
MVP

From Sunny's example

Class(Age, 5, 'X') as Class2

First Class starts from 0 to 5 as no offset is given... 1st class is 0<=X<5

But for below example

Class(Age, 5, 'X', 3) as Class1

Offset is 3..and Class range is 5... Here with offset the 1st Class with end with the offset value i.e. 3

So the range would be