Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Announcing the newest addition to the Qlik Community, Qlik Gallery! Learn More
Highlighted
balrajahlawat
Esteemed Contributor

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
MVP

Re: Offset in Class()

If no offset, the first range with Start with 0

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

SIMPLE !

17 Replies
Chanty4u
Esteemed Contributor III

Re: Offset in Class()

hi,

example

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

jyothish8807
Honored Contributor II

Re: Offset in Class()

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
balrajahlawat
Esteemed Contributor

Re: Offset in Class()

Dear,

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

Re: Offset in Class()

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:

Capture.PNG

balrajahlawat
Esteemed Contributor

Re: Offset in Class()

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?

balrajahlawat
Esteemed Contributor

Re: Offset in Class()

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

Re: Offset in Class()

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

balrajahlawat
Esteemed Contributor

Re: Offset in Class()

mean to say,

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

MVP
MVP

Re: Offset in Class()

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