Top 10 Customers by Total Tons per Week

[#1]

I am new to qlickview and have a simple request that seems to be more complicated than I would have thought.  I need to display the top 10 customers by week based on a metric of SUM(METRIC TONES)

If I have The customer and the week in the dimensions and the follwoing formula in the expressions I get the correct ranking:

Rank(SUM(METRIC_TONS))

The issue is I only want to see the top 10 customers based on that ranking.  I have tried a few different versions of what I thought would be needed as a calculated dimension, but all my formulas just output //error calculateing formula.

Not sure how to go about this, any direction would be wonderful.

Jim

[Nicole-Smith]

If you are using QlikView 11, you can use Dimension Limits.

Check "Restrict which values are displayed using the first expression" on the Dimension Limits tab.  Then, choose "Show only" and "Largest" and type in "10" for Values.

I hope this is helpful!

[Or]

You could use something along the lines of:

IF(AGGR(RANK(SUM(METRIC_TONS)), CUSTOMER) <= 10,CUSTOMER)

I think that's the right syntax, anyway. If you have QV11, Nicole's tip is much better.

[#4]

orsh_ would this be a caluclated dimension or an expresion?

[lotfiblo]

Hi,

it is a calculated dimension

and in the "expressions" put only SUM(METRIC_TONS)

Lotfi