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).
Table in database:
In my table in qlikview I have to show:
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.