Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
m_perreault
Creator III
Creator III

Only Max Value by a Dimension

Hi All,

I have a table

Company% of Sales
Company A.5
Company B.25
Company C.25

My expression for % of Sales is Max(Aggr(Sum(Sales)/Sum(Total Sales),Company))  which I was hoping would return only one row which shows the company with the highest % of Sales such as below.

Company% of Sales
Company A.5

Does anyone know how to accomplish what I am looking for?

Thanks,

Mark

Labels (1)
1 Reply
JaMajka1
Partner Ambassador
Partner Ambassador

Hi Mark,

try to use this expression instead of your dimension:

=if(%_of_sales=aggr(max(total %_of_sales),company),company)

BR,
Maria