Highlighting a entire row for max/min column condition in a table

[#1]

Hi,

     I wish to highlight the entire row ( or few columns of my choice) with different background in the attach qvw when a max. or min value in the table.  In my case I am checking for max. business performance across all the regions and highlighting that region. Visual cues seems to handle only the selected column on which the max. and min. condition is set.

The rows should get highlighted only when the records displayed are more than 2. It should not highlight the total shown at the bottom.

Please assist.

Thanks

Laxmikant

[#2 · Accepted solution]

Hi,

Please find attached file. Is this how you want it?

Regards

Arun

[#3]

Thanks Arun for the solution. But it works with sample/test data. With the actual data in my application I am not able to get this work. the if condition does return false always.

Please find the attach screen shot.

[#4]

Can u upload the doc for me to take a look at it.

Arun

[#5]

After further analysis its now working. The thing that has to be taken care is rounding off the data explicitly while comparing.

For eg. the data for that column is made as an integer data type and displayed in % using the object properties Number tab. So on screen for eg. the number that display -17% actually is holding the value -16.6696454 where as the variable has calculated the value to -16.669645391231. so comparision failed.

[#6]

Ok gr8. Pls mark the discussion as answered.

Thanks

Arun

[#7]

One more thing ...you can add one more piece of code so that the row gets highlighted only when more than two rows are selected:

if

(Performance=var_performance and GetPossibleCount(Region)>2,green())

See test3 file attached