Pivot Chart Top 10 - Not using rank

[#1]

Hi All,

Is it possible to have a solution where I can get a top 10 x of individual companies selected?

I have tried the rank function but this does not working correctly and our reseller consultant says this has a bug with qlikview version 8.5.

Setting the option to display only 10 rows within the chart properties will also not work as I need to display the top 10 for each company separately.

Thanks,

Kevin.

[#2]

Hi!

Can you contribute with what information the companies are going to be sorted after? Alphabetical? Expression? What does "top" refer to in this case?

//Jakob

[hector]

Hi,

more info please, is this a bar chart? pivot table with 1st dim company?

c ya!

[#4]

Hi Jakob,

I need it to be sorted after the top 10 of an expression which is a sum of sales - Numeric.

Thanks,

Kevin.

[#5]

Hi Hector,

This is a pivot chart. The top 10 will be based on an expression which is the sum of all sales - numeric.

Thanks,

Kevin.

[#6]

If you have an expression that sums the sales, and need to sort out the top 10 sales, then you might aswell use the very same expression that sums the sales as sorting expression, then sort on descending order.

In some rare cases, if it doesn't work, make sure you use the "=" in front of the sorting expression in the sort order tab i.e. =sum(Sales).

Hope this helps

//Jakob