how to assign sequential rank to the values of a column in straignt table

[vishus913]

hi all,

as the rank function is here giving the ranks from 1 to 4 then it gives the ranks as 7 and 9, i want these to assign 5 and 6 ?

is there a way i can do it in qliksense

thanks in advance

[sunny_talwar]

May be check this out

Continuous Ranking (no missing Rank)

[vishus913]

i tried to implement that already

but it didnt work

[sunny_talwar]

Would you be able to share a sample file where you tried it? It would be nice to see what you have tried and help you fix it rather than starting from scratch.

Best,

Sunny

[vishus913]

Hi sunny,

I've attached the sample QVF,

where it outputs 3 only

[sunny_talwar · Accepted solution]

See if this works

Num(Aggr(NODISTINCT Rank(TOTAL id, 1, 1),id, name))

[vishus913]

hi sunny,

thanks a lot for the help

it works fine, but i want to know how it works

can u please elaborate

[sunny_talwar]

Ranking the ID by just using the ID dimension through Aggr() function and then using NODISTINCT to display the same number for the same repeating ID.