topic Re: highlight min/max values in straight table in QlikView

highlight min/max values in straight table

Tue, 17 Dec 2013 09:28:37 GMT

Hi all,

I want to highlight min/max values in a straight table for each column.

how can I do it?

Thanks,

Boris

Re: highlight min/max values in straight table

swuehl — Tue, 17 Dec 2013 09:37:36 GMT

Try a background color expression attribute (on expression tab, open the attributes by clicking on the plus sign next to the expression label), something like

if(rank( EXPRESSION) = 1, lightgreen(),

if(rank( -EXPRESSION) = 1, lightred()

)

Re: highlight min/max values in straight table

babitaku — Mon, 18 Nov 2019 11:07:09 GMT

For Maximum value, results are coming right but to highlight minimum results are not coming.

I am using below expression:

If(rank(Total Salary)=1,Green(), ---Correct
If(rank(-Total Salary)=1,Yellow())) ---Not Correct

Any Help would be appreciated!

Babita

Re: highlight min/max values in straight table

Majed — Wed, 04 Jan 2023 08:52:12 GMT

I prefer using a simpler way

if (rank (column(1)) =1, Green() ,if (rank (-column(1)) =1, red() ))

where column(n) is the number of the column, counting measures only.