topic "Class-like" function in QlikView

"Class-like" function

pedromsouza — Sat, 26 May 2018 20:56:19 GMT

Is there a function that works like "class", but instead of '20<=x<30', '30<=x<40'... would give me just the max? 30, 40...

I tried right(class(expression)) but it didn't work.

Frank_Hartmann — Sat, 26 May 2018 22:10:21 GMT

perhaps like this:

right(class(expression,10),2)

or better:

subfield(class(expression,10),'<',3)

pedromsouza — Sun, 27 May 2018 12:03:41 GMT

Thanks Frank. It worked with "right".

if(num(right(class(EXP,8),2))=0,1,num(right(class(EXP,8),2)))

Frank_Hartmann — Sun, 27 May 2018 12:21:56 GMT

but be aware that this function only works if the max intervall is smaller than 100.

for expression results above 100 you should better use the subfield solution.....

hope this helps

pedromsouza — Sun, 27 May 2018 12:42:17 GMT

I had not realized that. I'll use subfield instead. Thanks again.

MarcoWedel — Sun, 27 May 2018 21:51:00 GMT

Floor(expression,10)+10

might do as well