Class limit possible?

xtrimf — Sun, 30 Aug 2009 19:42:16 GMT

Hi,

When using the class function is it possible to limit its high value?

For example if it is used on month like this: class(Month,7)

then the results will be "0<=Month<7" and "7<=Month<14"

14 is not a month....I need it to write "Month>=7"

Any suggestion?

tnx

prieper — Mon, 31 Aug 2009 01:33:41 GMT

Hi,

you can add an if-clause to your class-function, like: If(YourValue > 10, '>10', class(YourValue, x))

HTH

Peter

topic Class limit possible? in QlikView