topic Table with Top15 Selection in QlikView

Table with Top15 Selection

Mon, 25 Oct 2010 14:53:32 GMT

Dear,

I know it's possible to make a graph where you select only the top 15 of customers for example,

but can someone tell me if it's also possible to make a table (pivottable) where I only want to see the top 15 customers with theie sales figures for a couple of months, and how I can make this?

thanks in advance

Table with Top15 Selection

Miguel_Angel_Baeyens — Mon, 25 Oct 2010 15:29:59 GMT

Hello,

Assuming you have a "CustomerID" as field and figures of sales are recorded in "Amount" field, I would do a calculated dimension something like

=If(aggr(rank(aggr(sum(Amount), ID), 4, 2), CustomerID) <= 15, CustomerID)

Then check "Suppress null values" for that dimension, then use

Sum(Amount)

as expression.

Hope that helps!

Table with Top15 Selection

Mon, 25 Oct 2010 16:14:10 GMT

Works perfect!

Thanks