Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

vishus913
Contributor

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

hi all,

3afb4e818b3048828286a1d7538b6e90.jpg

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

1 Solution

Accepted Solutions

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

See if this works

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

7 Replies

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

vishus913
Contributor

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

i tried to implement that already

but it didnt work

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

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
Contributor

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

Hi sunny,

I've attached the sample QVF,

where it outputs 3 only

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

See if this works

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

vishus913
Contributor

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

hi sunny,

thanks a lot for the help

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

can u please elaborate

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

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.

Community Browser