Rank Select Company

[#1]

Hi,

I´m new in Qlik and need some help...

I need to put in a text object the sales rank of a selected company in a list box.

I ranked ok in a table but I only want the rank for that specific company in a text object

The expression used in the table is:

=Rank({<ProductName=, CompanyName=>}Sum(ProjectedSalesValue))

Thanks in advance,

Francisco

[MK_QSL · Accepted solution]

=Aggr(Rank(TOTAL SUM({1}ProjectedSalesValue),4),CompanyName)

OR

=Aggr(Rank(TOTAL SUM({1<ProductName=>}ProjectedSalesValue),4),CompanyName)

[lironbaram]

try this one

=max({<CompanyName=>}aggr(Rank(Sum({<ProductName=>}ProjectedSalesValue)),CompanyName))

have a look at the attach example

[#4]

Great tip!

=Aggr(Rank(TOTAL SUM({<ProductName=, CompanyName=>}ProjectedSalesValue),4),CompanyName)

Thanks a lot,

Francisco.

[MK_QSL]

Glad that you got your solution...

Please close the thread by selecting appropriate answer....

[#6]

How do I do that,

Thanks,

Francisco

[#7]

Forget the last message, I found out...