Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
paulyeo11
Master
Master

How to flag highest EPS company ?

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

1 Solution

Accepted Solutions
sunny_talwar

You want to flag it? May be try this:

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

Capture.PNG

View solution in original post

6 Replies
paulyeo11
Master
Master
Author

my QVF

sunny_talwar

You want to flag it? May be try this:

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

Capture.PNG

paulyeo11
Master
Master
Author

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
Master
Master
Author

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
Master
Master
Author

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