Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Announcing the newest addition to the Qlik Community, Qlik Gallery! Learn More
larisa_filonova
Contributor III

Ranking Value

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

1 Solution

Accepted Solutions
MVP
MVP

Re: Ranking Value

Try

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

edit: changed Rank()

2 Replies
MVP
MVP

Re: Ranking Value

Try

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

edit: changed Rank()

larisa_filonova
Contributor III

Re: Ranking Value

Thank you!