Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Highlight a value in a table, What expression would be best?

Thank you Everyone!

Last weekend I've been fighting with my expression to highlight the maximum Quantity amount as showed here:


  

I would like the Brazil Quantity 3,358,230 to be in green.

I used different expressions:

=if((Max(Quantity), Quantity rgb(0,255,0), Quantity)

=IF(Sum( {$<Quantity={"<=$(=Max(Quantity))"}>} Quantity),rgb(0,255,0)

=firstsortedvalue( Quantity, -Aggr(Max([Quantity]),Quantity,rgb(0,255,0)))

Unfortunately none is working! Again maybe my expressions are totally wrong.

Thanks for your advise and insight!

1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

I assume you need help with the background color (or maybe text color) expression for Quantity column.  Try this:

if(Quantity=max(total Quantity, rgb(0,255,0)))

Edit: if I got it wrong, upload your app.

View solution in original post

4 Replies
Anonymous
Not applicable
Author

I assume you need help with the background color (or maybe text color) expression for Quantity column.  Try this:

if(Quantity=max(total Quantity, rgb(0,255,0)))

Edit: if I got it wrong, upload your app.

Not applicable
Author

Thanks Michael!

Yes, for either the text or the Background color.

I'm going to try this out tonight.

Thanks again!

Anonymous
Not applicable
Author

This rgb looks too light for text.  Well, you'll figure out.

JonnyPoole
Employee
Employee

Are you first summing the quantities from multiple records in your data model to get a by country sum ? 

If that is the case I'm wondering if you need aggr() here to first sum() and then get the max of the sums.

if(   sum(Quantity)=max(total aggr( sum(Quantity), pays) ), rgb(0,255,0)))