Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
=Aggr(Rank(TOTAL SUM({1}ProjectedSalesValue),4),CompanyName)
OR
=Aggr(Rank(TOTAL SUM({1<ProductName=>}ProjectedSalesValue),4),CompanyName)
=Aggr(Rank(TOTAL SUM({1}ProjectedSalesValue),4),CompanyName)
OR
=Aggr(Rank(TOTAL SUM({1<ProductName=>}ProjectedSalesValue),4),CompanyName)
try this one
=max({<CompanyName=>}aggr(Rank(Sum({<ProductName=>}ProjectedSalesValue)),CompanyName))
have a look at the attach example
Great tip!
=Aggr(Rank(TOTAL SUM({<ProductName=, CompanyName=>}ProjectedSalesValue),4),CompanyName)
Thanks a lot,
Francisco.
Glad that you got your solution...
Please close the thread by selecting appropriate answer....
How do I do that,
Thanks,
Francisco
Forget the last message, I found out...