Ranking Value

[Anonymous]

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

[swuehl · Accepted solution]

Try

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

edit: changed Rank()

[Anonymous]

Thank you!