topic How to get rank properly when multiple dimension have same metric value ? in QlikView

How to get rank properly when multiple dimension have same metric value ?

shekhar_analyti — Wed, 25 Nov 2020 16:16:04 GMT

Hi All ,

How to get rank properly when multiple dimension have same metric value ?

Item	Sale	Rank
A	20	1
B	10	2
C	8	3
D	5	4-5
E	5	4-5
F	2	6-7
G	2	6-7
H	1	8-9
I	1	8-9

Expected

Item	Sale	Rank
A	20	1
B	10	2
C	8	3
D	5	4
E	5	4
F	2	5
G	2	5
H	1	6
I	1	6

Re: How to get rank properly when multiple dimension have same metric value ?

sunny_talwar — Tue, 20 Mar 2018 12:59:40 GMT

Just what you need

Continuous Ranking (no missing Rank)

Re: How to get rank properly when multiple dimension have same metric value ?

shekhar_analyti — Tue, 20 Mar 2018 13:02:12 GMT

Response for Faster than time taken to submit after pressing post button

Re: How to get rank properly when multiple dimension have same metric value ?

sunny_talwar — Tue, 20 Mar 2018 13:02:15 GMT

Use this expression

Div(Index('-' & Concat(DISTINCT TOTAL Num(Aggr(Rank(Sum(Sales),1,1), Item), '00000'), '-', -Aggr(Sum(Sales), Item)), Num(Rank(Sum(Sales),1,1), '00000')), 6) + 1