Rank

[#1]

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

[#2]

In a straight table put Customer as the dimension and the following expressions:

1. Sum(Sales)

2. Rank(Sum(Sales))

[v_iyyappan · Accepted solution]

Hi,

     I attached a sample application for using rank function.its satisfy for ur requirments.

Hope its helpful for u.

Regards,

Iyyappan

[#4]

THANKS SO MUCH!!!