Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Ranking (Ignoring 2nd dimension)

Hello All,

In the attached file , I am ranking as per customer.

As for customer 8 which is at rank 1, i want all brands also to get same rank which is one.

Then all brands with customer 7 should have rank 2....

What is the expression to achieve above requirement.

1 Solution

Accepted Solutions
sunny_talwar

Try this:

=Aggr(NODISTINCT rank(sum([Sales]),[Customer]),[Customer])

Capture.PNG

View solution in original post

2 Replies
sunny_talwar

Try this:

=Aggr(NODISTINCT rank(sum([Sales]),[Customer]),[Customer])

Capture.PNG

Not applicable
Author

Thanks Sunny. It works..