Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
Not applicable

highlighting highest numbers

Any way to be able to do this?

Tags (1)
3 Replies
cwk
New Contributor III

Re: highlighting highest numbers

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

MVP
MVP

Re: highlighting highest numbers

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
Valued Contributor III

Re: highlighting highest numbers

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()))