topic Re: Problem with Customer sales ranking in QlikView

Problem with Customer sales ranking

Tue, 15 Apr 2014 14:58:50 GMT

Hi, I have a table in my database with the columns: Product, Customer and Amount.

I need to show in a table the ranking of the Customer for a product. The problem is that in the table I have filtered the product and the customer and the rank is 1 every time I tried (or null).

Example:

Table in database:

Product	Customer	Amount	Ranking Proposed
PR1	CUST1	1000	3
PR1	CUST2	1500	2
PR1	CUST3	500	4
PR1	CUST4	2000	1

In my table in qlikview I have to show:

Product	Amount	Ranking
PR1	1500	2

The Customer is filtered to CUST2 and this table contains only one row.

I've tried with aggr and rank but I always get Ranking 1.

Any idea?

Regards,

Oscar.

Re: Problem with Customer sales ranking

MK_QSL — Tue, 15 Apr 2014 15:23:29 GMT

Try

Straight Table

Dimension

Product

Expression

SUM(Amount)

Aggr(Rank(SUM({1}Amount),4),Product,Customer)

Aggr(Rank(SUM({1}Amount),4),Customer)

Re: Problem with Customer sales ranking

Wed, 16 Apr 2014 07:36:17 GMT

Thank you very much, Manish. The first solution proposed works,