topic Condition using MAX() in IF... else in QlikView

Condition using MAX() in IF... else

Wed, 28 Sep 2011 18:23:01 GMT

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??

Condition using MAX() in IF... else

swuehl — Wed, 28 Sep 2011 18:56:12 GMT

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

Condition using MAX() in IF... else

Fri, 30 Sep 2011 16:09:39 GMT

Was trying to use it as an expression...

Condition using MAX() in IF... else

swuehl — Fri, 30 Sep 2011 17:28:18 GMT

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?

Re: Condition using MAX() in IF... else

RodolfoNeumann — Fri, 20 Sep 2019 20:56:30 GMT

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?