Smallest Dimension limits

[jchoucq]

HI everybody,

for example, i want to show the 5 smallest sales in a bar chart and when i use Smallest Dimensions Limits, the bar chart gives no data to display because many salesman have no sales !

Is it possible, in a bar char to have the 5 smallest values, which are different from zero.

Regards,

Johann

[MayilVahanan]

HI

You can use rank() function for that,

for ex:

in expression

if(rank(sum(Sales)) < 5, sum(Sales))

greater than zero,

u can use like this

=if(rank(sum({<Sales = {'>0'}>}Sales)) <=5, sum(Sales))

hope it helps

[christian77]

Watch! rank fuction = 1 is first, no last. 2 is the second, and so on. is there an inverse rank?

example kank(Vettel) = 1, rank(Alonso)=2, ......, rank(last), we don't know. How many are they?

If is a simple table, use dimension limits.

In the presentation tab check suppress cero values.

[jchoucq]

it seems that suprress 0 value with smallest in the dimensions limits doesn't work.

I will try to send an example

[MayilVahanan]

Hi

For inverse,

rank(-sum(Sales))

hope it helps

[jchoucq]

thank you for your answers.

as a conclusion, the smallest option in the dimension limits is diffocult to use without writing a specific expression. See qvw in attachement

[MayilVahanan]

Hi

PFA

[jchoucq]

thank you, i know this method in a straight table, but we can't do the same in the bar chart below !

[MayilVahanan]

Hi

PFA

Hope it helps

[jchoucq]

Thank you very much Mayil. It works indeed.

But i noticed you don't use Dimensions Limits