topic Re: How to show Top 10 largest in 'magnitude' in bar chart in QlikView

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

Wed, 30 Oct 2013 09:47:04 GMT

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!

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

Wed, 30 Oct 2013 09:59:01 GMT

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.

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

tresB — Wed, 30 Oct 2013 10:02:35 GMT

Please see the qwv attached.

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

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

Anonymous — Wed, 30 Oct 2013 15:02:11 GMT

I suggest sort order descending, by expression

fabs(sum(VaRMove))

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

Wed, 30 Oct 2013 15:22:53 GMT

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