Top 10 Rank

[jamelmessaoud]

Hi guys,

I have an expression

=SUM({<CalDateMonth ={$(vCurrentMonth)}>} Revenue)

Is there any way I can add the Rank function to this and show the top 10 ?

Thanks

J

[olivierrobin]

hello

why don't you use dimensional limits tab in your graph ?

[jamelmessaoud]

I would like to add a couple of other measures also and not just the revenue if that makes sense?

[olivierrobin]

you can add all measures you need and limit the display by using one or more of this measure

in your case, you could all a measure giving the rank and limit the display to the n first values

[jamelmessaoud · Accepted solution]

Figured this out now.  Should really use the search function before posting shouldn't I.

I found this thread

Re: Rank in a table chart with data filter

[Anil_Babu_Samineni]

May be use this?

SUM({<FieldName = {"=Rank(SUM({<CalDateMonth ={$(vCurrentMonth)}>} Revenue))<=10"}>}Sales)

[olivierrobin]

now you have a lot of solutions to your problem. Be careful that the end of the post seems to be QlikSense.

[jamelmessaoud]

This is the exact expression which i used.  Thanks guys