topic Match with intervals at object level in QlikView

Match with intervals at object level

danielact — Wed, 30 May 2012 14:24:18 GMT

I am currently using a Match function instead of nested if statements because my data source is enormous, and if statements really slow it down. Now I'd like to use an interval instead of just a number - so instead of using Match(Num,1,10,100,500) I'd like to be able to do within 5 of each value - so instead of 10, it would be between 5 and 14, etc.

Any idea on how to do that?

Match with intervals at object level

RedSky001 — Wed, 30 May 2012 14:45:40 GMT

load *

,Qty - 5 as Start

,Qty + 5 as End;

LOAD * INLINE [

Qty

20,

];

LOAD * INLINE [

];

IntervalMatch ( X ) load Start, End Resident A;

drop tables A, B;

Does this help?

Mark

Match with intervals at object level

Wed, 30 May 2012 23:12:13 GMT

Try to use Class function, where you basically create buckets. Here is example from help:

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'