Discussion Board for collaboration related to QlikView App Development.
Can somebody help me to find out how Offset works in Class() Function??
How this 3 will be used in calculation while calculating expression?
If no offset, the first range with Start with 0
If offset, the first range will end with that offset integer...
class( var,10,'x',5 ) with var = 23 returns '15<=x<25
In class function 0 is normally the default starting point of the classification. By setting an offset you can change the default starting point.
I already know this, I am asking how offset 5 is getting calculated here?
Seems to determine where you class starts from. Look at this example:
Class(Age, 5, 'X', 3) as Class1,
Class(Age, 5, 'X') as Class2;
LOAD Ceil(Rand()* 99) as Age
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?
Sunny, thanks for sharing this...My concern is how this offset value change the min and max value?
Change the min and max value? of the underlying field?
mean to say,
For age 1, with offset how it is giving -2<=x<3
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