Rngesum Rank issue

[#1]

Need help for rank accumulation .

I have used formula

rangesum(rank(total column(1)))

result is not showing properly after  rank 55 .PFA  excel for detailed information

[jonathandienst]

That expression will sum the ranks, which is probably not what you want. Explain what you are trying to do clearly, what does your input look like and what result you are hoping for.

[Chanty4u]

rangesum(above(sum(Value), 0 , RowNo()))

[Kushal_Chawda]

see the below.. You can probably do it in script

Re: Ranking issue in qlikview

[#5]

Thnx Kush ,but i want it in front end expression

[Kushal_Chawda]

try this expression

=rank(sum(index))

[settu_periasamy · Accepted solution]

Hi,

Try this..

rangesum(rank(total Column(1),1))

[#8]

Thnx ..this expression worked