Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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))
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)