Top N with Ranking Number

[JaneNewbie]

Hi Guys, 

I am new to Qlik. So I am looking for a way, could be an expression to get the top 10 value with their corresponding rank numbers. Output should look like the table below with Comp B being the top performer.

Company      Rank

Comp B          1

Comp C           2

Comp D           3

Comp A           4

Thank you so much!

[chaorenzhu]

Is Rank already a field? If so you can simply Limitation -> Fixed Number -> Top 10 -> untick show others

[JaneNewbie]

Thank you for the reply. So there is no rank field. There's only the amount per company. I only got the rank using rank(sum(amount)) but I need to show only the top 10 in the table. Is there a way for that? Thank you so much 🙂

[chaorenzhu]

It would be the same. In a straight table add company as dimension and sum(amount) as measure, then limit the dimension to top 10 as indicated above

[JaneNewbie]

Oh my gosh! That easy? HAHA Sorry, laughing at myself. Been trying to use expression, didn't realize there is this function! Thank you so much. You are awesome for helping a newbie!!! 🙂