Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to Rank of Entire Group After Selection?

I have the following chart in qlikview:

Client Revenue RevRank

a 4 1
b 3 2
c 2 3
d 1 4

but when I click on client 'd' for example, I get:

Client Revenue RevRank

d 1 1

How can I edit my expression to make it so that when I click on 'd', I still get the overall RevRank:

Client Revenue RevRank

d 1 4

my current expression is: rank(sum(Sales))

1 Reply
johnw
Champion III
Champion III

So you don't want your rank to depend on selections? You could consider assigning it in the script if so to make the chart faster. That said, this expression appears to work:

aggr(rank(sum({1}Revenue)),Client)