Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
How do i highlight max value horizontally and vertically QV table
.
Jayanthan
Hi,
Can you provide a sample qvw?
In background color
if(max(total aggr( [yourCelCalc],LOCATION,WSG))=[youCelCalc],lightred())
where [yourCelCalc] is the the expression in the cel.
Please find attached
If you want to highlight the max and min in the TOTAL its not possible
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