Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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.
Please see the qwv attached.
Ranking does depend on your sort order. So see the sort order for appropriation.
I suggest sort order descending, by expression
fabs(sum(VaRMove))
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