topic Re: rank fun in QlikView

rank fun

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

i have 2 9's so im geting 2-3 and 2-3 as rand, for 8 i got 4 ,so i should get 3 as rank for 8,can i get the expression for tat

Re: rank fun

devarasu07 — Thu, 21 Dec 2017 08:25:54 GMT

Hi,

Check stalwar1‌ Solution,

Continuous Ranking (no missing Rank)

Re: rank fun

zhadrakas — Thu, 21 Dec 2017 08:26:19 GMT

cou could try this:

Rank(total aggr(Rank(concat(String&ID)), ID))

eventually you Need to uncheck "hide null values" in presentation tab

Re: rank fun

vignesh_s — Thu, 21 Dec 2017 10:09:27 GMT

i wanna display that value too

Re: rank fun

zhadrakas — Thu, 21 Dec 2017 10:30:30 GMT

there is definitely a better way to do it but you could use this expression

if(isnull(Rank(total aggr(Rank(concat(String&ID)), ID))),
above(Rank(total aggr(Rank(concat(String&ID)), ID))),
Rank(total aggr(Rank(concat(String&ID)), ID)))

Re: rank fun

vignesh_s — Thu, 21 Dec 2017 11:16:16 GMT

thank you