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

highlighting highest numbers

Any way to be able to do this?

3 Replies
Anonymous
Not applicable
Author

With Qlik Sense Pivot Tables - You can highlight the Cell Values based on your criteria.

This example shows highlighting the cells for all sales over $5000. 

This type of color expression needs to be placed in the Background Color Expression area of the Measure details on the right side of sense.

highlight.PNG

swuehl
MVP
MVP

To highlight the max value, you can use something as background color expression like


=If( Sum(Value)=Max(TOTAL Aggr( Sum(Value), Product, Customer)),Yellow())


Sum(Value) being the expression in the chart and Product, Customer the dimensions.

Gabriel
Partner - Specialist III
Partner - Specialist III

Hi,

Maybe try this below expression, select EDIT (little pencil icon at top right) then select Appearance then Colors then change the colors to By Expression.

IF(Sum([Value])=RANGEMAX(TOP(TOTAL Sum([Value]),1,NOOFROWS(TOTAL))),YELLOW())

Where YELLOW() is whatever color you want.

Here is the full function for Top and Bottom

IF(Sum([Value])=RANGEMAX(TOP(TOTAL Sum([Value]),1,NOOFROWS(TOTAL))),YELLOW()

,IF(Sum([Value]) = RANGEMIN(TOP(TOTAL Sum([Value]),1,NOOFROWS(TOTAL))),RED()))