Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Rank Functions

I am attempting to use Rank in a straight table and it is not working correctly.

This is an example of my two data tables

Company NameMoney
Company A10
Company B20
Company C45
Company D15
Company E25
Company F

30

Group NameCompany Name
Group 1Company A
Group 1Company B
Group 2Company C
Group 3Company D
Group 3Company E
Group 3Company F

So I then set up a straight table that looks like this

Group NameMoneyRank
Group 130-
Group 2451
Group 370-

My Rank formula is rank(Money), it is only ranking the one group that only has one company under it. Is there a way to fix this?

1 Solution

Accepted Solutions
srikanthsri1
Valued Contributor

Re: Rank Functions

Try this

=rank(aggr(sum(money),Groupname))

2 Replies
Not applicable

Re: Rank Functions

try Rank(sum(money))

srikanthsri1
Valued Contributor

Re: Rank Functions

Try this

=rank(aggr(sum(money),Groupname))

Community Browser