How to flag highest EPS company ?

[paulyeo11]

Hi All

I have a EPS by company for about 10 company. I want to flag the top highest EPS company.

I use below expression :-

max(aggr($(vEPS),COMPETITOR_k))

I get blank . Can some one advise me where i go wrong ?

Paul

[paulyeo11]

my QVF

[sunny_talwar · Accepted solution]

You want to flag it? May be try this:

If(Rank($(vEPS)) < 2, 1, 0)

[paulyeo11]

Hi Sunny

Thank you very much for your help.

I need the set point for flag dynamic , in case I select 2 stock , which EPS higher will be flag. Can you advise me how to do this ?

Paul Yeo

Director

www.tdstech.com<http://www.tdstech.com>

HP+6285883521036 Indo

[paulyeo11]

Hi Sunny

I relook at your expression , I think your is correct , now what I need is I want the column with EPS higher ranking mark with yellow Color on the back ground Color. So I don't need the flag column.

Paul Yeo

Director

www.tdstech.com<http://www.tdstech.com>

HP+6285883521036 Indo

[paulyeo11]

Hi Sunny

This is 100% what i am looking for. it work fine now.

Paul

[sunny_talwar]

Hahahaha I am glad it worked because I went to sleep after giving typing my response