Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
May be check this out
i tried to implement that already
but it didnt work
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
Hi sunny,
I've attached the sample QVF,
where it outputs 3 only
See if this works
Num(Aggr(NODISTINCT Rank(TOTAL id, 1, 1),id, name))
hi sunny,
thanks a lot for the help
it works fine, but i want to know how it works
can u please elaborate
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.