topic Re: Rank Select Company in QlikView

Rank Select Company

Mon, 28 Apr 2014 19:07:06 GMT

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 — Mon, 28 Apr 2014 19:11:52 GMT

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

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

lironbaram — Mon, 28 Apr 2014 19:17:47 GMT

try this one

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

have a look at the attach example

Mon, 28 Apr 2014 19:28:06 GMT

Great tip!

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

Thanks a lot,

Francisco.

MK_QSL — Mon, 28 Apr 2014 19:31:18 GMT

Glad that you got your solution...

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

Thu, 08 May 2014 10:37:01 GMT

How do I do that,

Thanks,

Francisco

Thu, 08 May 2014 10:39:05 GMT

Forget the last message, I found out...