syntax

[#1]

is their any syntax to get top values

say top 5 from a lot of 50

if yes what is it

thanks'

[michael_maeuser]

in frontend, try rank function or take a look at the dimension limits tab in chart properties (only straight table).

hope that helps

[sushil353]

Use rank function in dimension..

or you can use dimension limit option.

[tresesco]

See: Top 10 Rank and Dimension Limits?

[ashwanin]

Hi Deepak,

Hope below thread help you to find the answer with sample qvw of rank function.

Re: Top 10 With Total

[maleksafa]

you can use the Rank function for exampel rank(sum(sales)) or use the dimension limits tab, where you will define to show the top 10 or least 10 etc...

[ashfaq_haseeb]

Have a look at attached application.

Regards

ASHFAQ

[#8]

whats exactly the syntax for rank function..

say i need top 3 values

[ashfaq_haseeb]

Hi,

Look at my application attached in my previous post.

Regards

ASHFAQ

[MayilVahanan]

Hi

Try like this

Sum({<Product = {"=rank(sum(Sales))<= 3"}>} Sales)