Show rank of defined value, in text object

[#1]

Hi everyone,

I would like to display the rank of a company according to sum(Amounts) within a text object. Does anyone know what the expression within the text object would look like?

I thought it might be something like:

=Rank({<[Company]={'ABC'}>}Sum(Amounts))

But that returned an error. Help please!

[MK_QSL]

=Max({<Company ={'ABC'}>}Aggr(Rank(TOTAL SUM({1<Company =>}Amounts),4),Company))

[sunny_talwar]

Found this one to work without the use of alternate state.

=Concat({<Company = {'ABC'}>}Aggr(Rank(Sum({<Company= >}Amount)), Company), '|')

Give this a shot.

Best,

S

[sunny_talwar · Accepted solution]

Hey Manish,

I think he want the Rank to change on other selection, except the Supplier. So I think that the formula that would work for him would be:

=Max({<Company ={'ABC'}>}Aggr(Rank(TOTAL SUM({<Company =>}Amounts),4),Company)) (without the 1)

Best,

S

[MK_QSL]

Of course... I missed that. ....concentrated more on showing ACTUAL rank of ABC...

[#6]

It worked!!!!!! Thank you both!

[MK_QSL]

Andrew I worked hard for your question and got nothing 😞

[#8]

Sorry Manish! Sunindia technically had the correct answer - will a Helpful answer be enough?

[sunny_talwar]

Hey Manish,

Intention was not to take away your correct answer. I just thought that he should get what he wanted.

But hey man, we did help him out (we get his good blessings ;-)) Better than the points.

Best,

S

[MK_QSL]

Guys... I was just kidding...Dont worry.. I am not running after points...

My only objective is to help others who are struggling and at the same time learn something new practically...

So, dont worry at all.. !!!

By the way, Andrew, I like your question most.. It was challenging !

Happy Qliking !

[#11]

Awesome! It's good to hear that my questions are becoming more challenging as I get better with Qlikview...