QlikView App Dev

[pedromsouza]

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 · Accepted solution]

perhaps like this:

right(class(expression,10),2)

or better:

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

[pedromsouza]

Thanks Frank. It worked with "right".

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

[Frank_Hartmann]

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]

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

[MarcoWedel]

Floor(expression,10)+10

might do as well