Show top 5 bottom 5

[#1]

Hi,

Any idea how to show bottom 5 in a chart?

Regards,

CS Khoo

[tresesco]

Community is full of ideas. You have to just search : Re: Bottom 5 values

[its_anandrjs]

If the chart is straight and bar charts then you can use the dimension limits option in the QV 11.0 if using any other version then use variables for that.

[MayilVahanan]

Hi

Try like this

Top 5

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

Bottom 5

= If(rank(-sum(Sales))<=5,Customer)

[amit_saini]

Hi Cs,

Please see the attachment for top 20 and bottom 20 .

Thanks,
AS

[its_anandrjs]

Take the straight chart and dimension and expression

1.And then create a variable named vTop and take input box for enter value on the chart

2.Then in dimension limits check the limit option and select Smallest and write variable like =vTop+1

3.For Largest do same on another chart.

[#7]

Thanks. Anyway I solved the problem. I need to put some consideration because my application contains direct discovery feature.