Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
paulyeo11
Valued Contributor II

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

Re: How to flag highest EPS company ?

You want to flag it? May be try this:

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

Capture.PNG

6 Replies
paulyeo11
Valued Contributor II

Re: How to flag highest EPS company ?

my QVF

Re: How to flag highest EPS company ?

You want to flag it? May be try this:

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

Capture.PNG

paulyeo11
Valued Contributor II

Re: How to flag highest EPS company ?

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
Valued Contributor II

Re: How to flag highest EPS company ?

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
Valued Contributor II

Re: How to flag highest EPS company ?

Hi Sunny

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

Paul

Re: How to flag highest EPS company ?

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