Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

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

Re: Max and Min

Hi,

Can you provide a sample qvw?

sgrice
Contributor II

Re: Max and Min

In background color

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

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

Not applicable

Re: Max and Min

Please find attached

Re: Max and Min

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

antoniotiman
Honored Contributor III

Re: Max and Min

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

Community Browser