# QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Skip the ticket, Chat with Qlik Support instead for instant assistance.
cancel
Showing results for
Did you mean:
Anonymous
Not applicable

## 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
MVP

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

SIMPLE !

17 Replies
MVP

hi,

example

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

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
Anonymous
Not applicable
Author

Dear,

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

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:

Anonymous
Not applicable
Author

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?

Anonymous
Not applicable
Author

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

MVP

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

Anonymous
Not applicable
Author

mean to say,

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

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