topic Top 10 Customers by Total Tons per Week in QlikView

Top 10 Customers by Total Tons per Week

Wed, 30 May 2012 13:26:56 GMT

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

Top 10 Customers by Total Tons per Week

Nicole-Smith — Wed, 30 May 2012 14:12:56 GMT

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!

Top 10 Customers by Total Tons per Week

Or — Wed, 30 May 2012 14:21:34 GMT

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.

Top 10 Customers by Total Tons per Week

Wed, 30 May 2012 14:32:37 GMT

orsh_ would this be a caluclated dimension or an expresion?

Re: Top 10 Customers by Total Tons per Week

lotfiblo — Thu, 20 Sep 2012 09:11:26 GMT

Hi,

it is a calculated dimension

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

Lotfi