topic class function explination? in QlikView

class function explination?

Wed, 09 Jul 2014 05:43:09 GMT

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

i understand how it works my doubts is '5' what it do here?

Re: class function explination?

Anonymous — Wed, 09 Jul 2014 05:49:09 GMT

5 is actually a offset. If you don't put anything, the bucket will start from 0. In above case the bucket will start from 5. So you will get '5<=x<15', '15<=x<25', '25<=x<35' value in class field.

Re: class function explination?

its_anandrjs — Wed, 09 Jul 2014 05:59:21 GMT

From Help about the Class function check this

class(expression, interval [ , label [ , offset ]])

Creates a classification of expressions. The bin width is determined by the number set as interval. The result is shown as a<=x<b, where a and b are the upper and lower limits of the bin. The x can be replaced by an arbitrary string stated in label. 0 is normally the default starting point of the classification. This can be changed by adding an offset.

Examples:

class( var,10 ) with var = 23 returns '20<=x<30'

class( var,5,'value' ) with var = 23 returns '20<= value <25'

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