Ranking issue in qlikview

[#1]

Hello Friends,

Need your help urgently!!!

I need to sort the values as per attached excel .Rank column marked in yellow color.

Please help me for sorting this number in descending order

NOTE:I need to do this in front end.

[#2]

I gotthe answer

logic used is rangeavg(rank(column(1)))

[Kushal_Chawda]

Data:

Load Name,

           [D name],

           [Index for month]

FROM Table;

New:

noconcatenate

LOAD *,

           if([Index for month]=previous([Index for month]),peek('Rank'),rowno()) as Rank

Resident Data

order by [Index for month] desc;

drop table Data;

[Chanty4u]

cool:)

Please close the thread by making correct answer.

[#5]

i want it in front end expression