Condition using MAX() in IF... else

[#1]

I surprised to find out that Max() cant be used in conditional statement of IF. I was trying to use ::

if(max(marks)=marks, Rollnumber)

type of statement. but its showing "error in expression".

Even set analysis isnt helping to get solution :

sum({$<marks={$(max(marks))}>} Rollnumber)

Is it something wrong with my approach or QV doesnt allow function in Conditions??

[swuehl]

Hi,

where do you want to use this expression (in what kind of object, as calculated dimension or expression, if as expression, what are your dimensions)?

Anyway, I think the set expression should look like

=sum({<marks= {"$(=max(marks))"}>} Rollnumber)

Regards,

Stefan

[#3]

Was trying to use it as an expression...

[swuehl]

This is not much of information, is it? If you tell us a little more, the probability that someone around could help you will increase.

If I use a similar expression like the first in your original post, I don't get an "error in expression". marks and Rollnumber are field names and correctly spelled? You don't use the above expression as part / within another expression, like within an aggregation function?

[RodolfoNeumann]

I tried to use:

[Prazo]:
LOAD id_campo,
IF(condition, MAX(campo1), MAX(campo2)) as campo3
RESIDENT tab1
GROUP BY id_campo;

and it didn't work. What's wrong?