Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I want to rank top customers. For example from this
Customer Sales
ABC 500
123 750
qwy 235
987 1,256
I want qlikview to give me this
Customer Sales Rank
ABC 500 3
123 750 2
qwy 235 4
987 1,256 1
Hi,
I attached a sample application for using rank function.its satisfy for ur requirments.
Hope its helpful for u.
Regards,
Iyyappan
In a straight table put Customer as the dimension and the following expressions:
1. Sum(Sales)
2. Rank(Sum(Sales))
Hi,
I attached a sample application for using rank function.its satisfy for ur requirments.
Hope its helpful for u.
Regards,
Iyyappan
THANKS SO MUCH!!!