Problem with Customer sales ranking

[#1]

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.

[MK_QSL · Accepted solution]

Try

Straight Table

Dimension

Product

Expression

SUM(Amount)

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

or

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

[#3]

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