topic Re: dimension ranked, same rank on each row in QlikView

dimension ranked, same rank on each row

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

Hello community,

I have a straight table like the printscreen below. I want a ranking on amount per person and the rankingno repeated on each row that 'belongs' to the specific person.

Also, in the situation below: I want to see two times '1' , three times '2' and four times '3'.

Re: dimension ranked, same rank on each row

Gysbert_Wassenaar — Thu, 29 Sep 2016 14:15:14 GMT

add the word nodistinct in the aggr function: aggr(nodistinct rank(.... etc.

Re: dimension ranked, same rank on each row

sunny_talwar — Thu, 29 Sep 2016 14:15:52 GMT

Try this:

=Aggr(NODISTINCT Rank(Sum(amount)),Person)

Re: dimension ranked, same rank on each row

jharke — Thu, 29 Sep 2016 14:24:22 GMT

Hello Sunny

You and Gysbert were amazingly fast in responding with the correct answer. Gysbert was a bit faster (talking about seconds), at first I would like to give you the points to reach 100.000, but I see that you have already reached it recently. Congratulations!

Re: dimension ranked, same rank on each row

sunny_talwar — Thu, 29 Sep 2016 14:25:59 GMT

Hahahaha Thank you

Re: dimension ranked, same rank on each row

jharke — Thu, 29 Sep 2016 14:31:51 GMT

I did not find this NODISTINCT in combination with Ranking in any document. And could not find it in discussions, as I did not know how to search for. Now I have some threads for people who want more info:

Re: Ranking

Re: dimension ranked, same rank on each row

sunny_talwar — Thu, 29 Sep 2016 14:37:57 GMT

NoDistinct is not related to Rank, but it is more related to Aggr(). Since there is a dimension mismatch between your Aggr() function and your actual chart dimension, chart was only showing values for distinctly. Adding NoDistinct solves the issue here.

Read about grain mismatch here (point no.4)

Pitfalls of the Aggr function