topic Pivot Chart Top 10 - Not using rank in QlikView

Pivot Chart Top 10 - Not using rank

Fri, 14 Aug 2009 20:44:50 GMT

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.

Pivot Chart Top 10 - Not using rank

Fri, 14 Aug 2009 21:04:52 GMT

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

Pivot Chart Top 10 - Not using rank

hector — Sat, 15 Aug 2009 05:52:12 GMT

Hi,

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

c ya!

Pivot Chart Top 10 - Not using rank

Sat, 15 Aug 2009 06:03:30 GMT

Hi Jakob,

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

Thanks,

Kevin.

Pivot Chart Top 10 - Not using rank

Sat, 15 Aug 2009 06:07:22 GMT

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.

Pivot Chart Top 10 - Not using rank

Mon, 17 Aug 2009 14:58:40 GMT

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