topic Re: Doubt with Class function in QlikView

Doubt with Class function

Wed, 19 Aug 2015 17:11:17 GMT

I have this dimension

=IF(DIAS_PLAZO>=120, 'x =< 120', CLASS(DIAS_PLAZO, 30))

It's working ok, but i get this

0 <= x < 30

30 <= x < 60

60 <= x < 90

90 <= x < 120

And i wanna see this

0 <= x <= 30

30 < x <= 60

60 < x <= 90

90 < x <= 120

Is this possible?

Thank you

Regards,

sunny_talwar — Wed, 19 Aug 2015 17:19:41 GMT

May be just do this:

=IF(DIAS_PLAZO <= 30, '0 <= x <= 30',

IF(DIAS_PLAZO <= 60, '30 < x <= 60',

IF(DIAS_PLAZO <= 90, '60 < x <= 90',

IF(DIAS_PLAZO <= 120, '90 < x <= 120', 'x =< 120'))))

swuehl — Wed, 19 Aug 2015 17:22:08 GMT

You can easily replace the class() function with rounding functions ceil() and floor() , thus controlling which limit to exclude and include:

LOAD *,

if(ID>120, dual('x > 120',121) , dual(floor(ID, 30) & ' < x <= '& ceil(ID, 30), ceil(ID,30) ) ) as Class;

LOAD recno() as ID

AutoGenerate 121;

Clever_Anjos — Wed, 19 Aug 2015 18:08:50 GMT

Maybe this equivalent values

1 <= x < 31

31 <= x < 61

61 <= x < 91

91 <= x < 121

LOAD

class(RowNo(),30,'x',1) as c

AutoGenerate 120;