Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Max and Min

Hi All

How do i highlight max value horizontally and vertically  QV table

.Untitled picture.png

Jayanthan

5 Replies
Not applicable
Author

Hi,

Can you provide a sample qvw?

sgrice
Partner - Creator II
Partner - Creator II

In background color

if(max(total aggr( [yourCelCalc],LOCATION,WSG))=[youCelCalc],lightred())

where [yourCelCalc] is the the expression in the cel.

Not applicable
Author

Please find attached

avinashelite

If you want to highlight the max and min in the TOTAL its not possible

antoniotiman
Master III
Master III

Hi,

Vertically:

For each column, in Background color

If(RangeMax(Top(Column(1),1,NoOfRows()))=Column(1),Green())

column(2) in 2nd column and so on

Regards,

Anrtonio