Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
vishus913
Partner - Creator
Partner - Creator

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
sunny_talwar

See if this works

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

View solution in original post

7 Replies
sunny_talwar

vishus913
Partner - Creator
Partner - Creator
Author

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
Partner - Creator
Partner - Creator
Author

Hi sunny,

I've attached the sample QVF,

where it outputs 3 only

sunny_talwar

See if this works

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

vishus913
Partner - Creator
Partner - Creator
Author

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.