topic Re: Rngesum Rank issue in QlikView

Rngesum Rank issue

Tue, 29 Mar 2016 05:24:54 GMT

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

Re: Rngesum Rank issue

jonathandienst — Tue, 29 Mar 2016 05:28:23 GMT

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.

Re: Rngesum Rank issue

Chanty4u — Tue, 29 Mar 2016 05:29:13 GMT

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

Re: Rngesum Rank issue

Kushal_Chawda — Tue, 29 Mar 2016 05:35:57 GMT

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

Re: Ranking issue in qlikview

Re: Rngesum Rank issue

Tue, 29 Mar 2016 05:43:05 GMT

Thnx Kush ,but i want it in front end expression

Re: Rngesum Rank issue

Kushal_Chawda — Tue, 29 Mar 2016 05:54:18 GMT

try this expression

=rank(sum(index))

Re: Rngesum Rank issue

settu_periasamy — Tue, 29 Mar 2016 05:58:22 GMT

Hi,

Try this..

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

Re: Rngesum Rank issue

Tue, 29 Mar 2016 06:07:35 GMT

Thnx ..this expression worked