Offset in Class()

[Anonymous]

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?

[Chanty4u]

hi,

example

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

[jyothish8807]

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

[Anonymous]

Dear,

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

[sunny_talwar]

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

Table:

LOAD Age,

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

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

LOAD Ceil(Rand()* 99) as Age

AutoGenerate 1000;

Output:

[Anonymous]

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]

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

[sunny_talwar]

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

[Anonymous]

mean to say,

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

[MK_QSL]

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

SOMENUMBER <= X < 3

but you have Class Range is 5 so 3-5 = -2

Range is -2<=X<3