Ranking Value

Anonymous — Sat, 13 Feb 2016 13:10:54 GMT

Hi,

I'm using the formula =rank(sum({$<Brand=>} Quantity )) to set the Ranking Value for my brands.

But if some brands have the same Quantity, then QlikView assigns the same Ranking Value for them.

Still, I need the Ranking Value to be different because I assign different colors to brands based on the Ranking Value. Is ti possible?

Please see the file attached.

Thank you in advance,

Larisa

Re: Ranking Value

swuehl — Sat, 13 Feb 2016 13:27:36 GMT

Try

=num(rank(sum({$<Brand=>} Quantity ),4)

edit: changed Rank()

Anonymous — Sat, 13 Feb 2016 13:34:05 GMT

Thank you!