How to show Top 10 largest in 'magnitude' in bar chart

[#1]

Hi,

Please can anyone advice the following?

I want to limit the bar chart to show the top 10 in ‘magnitude’ (to include +ve and-ve), however the dimension limits tab seems to only support the option of the largest value in either  positive (use Largest) or negative (use Smallest). I have tried ‘First’ and that is not I  am looking for. I have attached the qvw. Please let me know if you have any suggestion.

Many
Thanks!

[#2]

Hi,

Can you more elaborate what you want.

As per my understanding you want top 10 whether they are +ve or -ve.

ex : -100,200,300,700,500,-400,900,1000,-800,1200,1300,1500.

then result should be 1500,1300,1200,1000,900,-800,700,500,-400,300.

Is that your requirement?

Sandy.

[tresesco]

Please see the qwv attached.

Ranking does depend on your sort order. So see the sort order for appropriation.

[Anonymous · Accepted solution]

I suggest sort order descending, by expression

fabs(sum(VaRMove))

[#5]

I would create a calculated dimension, sth like:

=Aggr(If(Rank(Sum(fabs(Magnitude))) <11, Product),  Product)

to get only the first 10 product according to absolute magnitude

The expression can be as simple as sum(magnitude)

Fabrice