topic Re: Re: Max function in QlikView

Max function

Anonymous — Tue, 23 Sep 2014 18:25:06 GMT

Hi, I have created a text object that displays Max([Score]). I get the highest score, but I want to also display the name who received the highest score. How do I add an expression to say give me the name of the person who scored max([score])? Thank you.

Re: Max function

ecolomer — Tue, 23 Sep 2014 18:28:52 GMT

Try this

Customer = p({<score={$(=max(score)-1)}>} Customer)

Re: Max function

Anonymous — Tue, 23 Sep 2014 18:34:55 GMT

I don't know what p is and it's not a good expression when I plug it in.

Re: Re: Max function

ecolomer — Tue, 23 Sep 2014 18:44:33 GMT

P = Possible (are slected)

See this manual for SET ANALYSIS

Re: Max function

muniyandi — Tue, 23 Sep 2014 19:00:02 GMT

Hi,

Try this expression.

= if(score=max(score),Customer) &'::'&max(score)

=Aggr(if(rank(max(score))=1,Customer),Customer)&':'&max(score)

Thanks,

Muni

Re: Re: Max function

Anonymous — Tue, 23 Sep 2014 19:21:27 GMT

Thank you so much!

Re: Re: Max function

muniyandi — Tue, 23 Sep 2014 19:25:15 GMT

Hi ,

You got result means mark it correct answer. It will helpful for others.

Thanks,

Muni