topic Re: Top 20 customer in a pivot table in QlikView

Top 20 customer in a pivot table

Thu, 02 Jul 2015 20:24:58 GMT

Hi, I need to pick my top 20 customer in a pivot table and som the sales. The dimensions I want to use is Company, SalesPerson and Year. Thus I dont want to show the customer but still calculate per customer.

So in eack cell below the sales value for the com´pany, salesperson and year should be shown, the will be different customers calculated.in each cell.

Can it be done and if so how?

//K

Company	SalesPeron	Year	2012	2013	2014	2015
1	A
1	B
2	C
2	D
3	E
3	F
3	G

Re: Top 20 customer in a pivot table

Qrishna — Thu, 02 Jul 2015 20:36:08 GMT

try

if(Aggr(rank(Sum({1}SalesQuantity)),[SalesPerson],Company,year)<=20,[SalesPerson])

Re: Top 20 customer in a pivot table

Thu, 02 Jul 2015 21:43:03 GMT

Hi Krishna,

No that does not work. I've tried several ways to solve this and

If(Aggr(Rank(Sum(SalesQuantity)), Company, SalesPerson, Year) <= 20, Sum(SalesQuantity))

If(Rank(Aggr(Sum({1}SalesQuantity), Company, CustomerNo, SalesPerson, Year)) <= 20, Sum(SalesQuantity))

Stil I need to have CustomerNo in the aggr function othervise I'll not aggegate over the customer.

/Klas

Re: Top 20 customer in a pivot table

Qrishna — Thu, 02 Jul 2015 21:55:21 GMT

can you post the qvw with some sample data.?