topic Re: Top 10 customers in QlikView

Top 10 customers

Tue, 22 Dec 2015 01:03:55 GMT

Edited by Qlik Community Member:

Please post in English unless you are in a dedicated language section.

Post translated by Google Translate.

---

Hi all,

I'm starting my first steps in QlikView and suddenly I find myself trapped in something that looks siemple but can not find how. I need to create a list of the top 10 customers. At first it seems siemple because vast to create the dimension "Client", using a Sum ({<TPO = {'Sales'}, YEAR = {'$ (= vAñoActual)'}>} GROSS) function that I can get selected sales per year that is stored in vAñoActual variable and select "Mostar the first 10" in the "Limitations of the Dimension". The result is as follows:

The problem is that the total shown does not correspond to the first 10 but the total of all customers.

There is way to show the total amount corresponding to the sum of the 10 primermos?

Greetings!

Re: Top 10 customers

tresB — Tue, 22 Dec 2015 07:14:51 GMT

Uncheck 'Show Others' in the dimension limit tab.

Re: Top 10 customers

Chanty4u — Tue, 22 Dec 2015 07:15:49 GMT

try below

Category= aggr(if(rank(sum(sales))<= 10, 'Top 10', 'Others'),name)

Top 10 Customers = aggr(if(rank((sales))<=10,name,'Others'),name)

Re: Top 10 customers

Kushal_Chawda — Tue, 22 Dec 2015 07:23:21 GMT

I think you need to customize your chart Using Rank function to achieve the same.

See the below link

Re: Rank with subtotals

Re: Top 10 customers

jagan — Tue, 22 Dec 2015 07:23:37 GMT

HI,

Try Unchecking the 'Show Others' option in the Dimension limits tab.

Regards,

Jagan.

Re: Top 10 customers

Tue, 22 Dec 2015 10:24:18 GMT

Hello,

Try this

In Dimensions Limit Tab : Remove Show Other and Show Total

In Expression Tab at Total Mode : Check the Sum of rows (The last option)

Regards

Gilles

Re: Top 10 customers

PradeepReddy — Tue, 22 Dec 2015 10:40:28 GMT

in 'Dimensions Limits ' tab,

1) Uncheck the 'Show Others' option

2) Select the 'Largest' option rather than 'First'