topic Re. :Change Color for the Max Value on a table line in QlikView

Change Color for the Max Value on a table line

jleraille — Tue, 13 Oct 2009 18:10:42 GMT

In a Pivot Table how can I identified for each line, le maxvalue to change his color ?

I tried whith Rangemax but it's not ok - what's the best way ?

Thanks fot your help

Jacques

Re. :Change Color for the Max Value on a table line

jleraille — Tue, 13 Oct 2009 20:55:17 GMT

use HRANK to have result.
For example in color condition : if (HRank(sum(Valeurs)/count(Critère))= 1,LightGreen())

Re. :Change Color for the Max Value on a table line

anitamelbye — Wed, 17 Mar 2010 08:33:31 GMT

Hi,

I have tried HRANK but it won't work, can someone please help me? I am doing something wrong, obviously!

I would have liked to have maxvalue in my prosent-columns marked with red text color.

I tried to write

if (HRank(SUM ( { $ < YEAR = { $(=MAX(YEAR))}, RNBILK = {4} >} -(RNBELØ)) /
 SUM ( { $ < YEAR = { $(=MAX(YEAR))}, RNBILK = {3} >} (RNBELØ)))= 1,RED())

..but it won't work..

I appreciate any suggestions 🙂

*newbee*

Re. :Change Color for the Max Value on a table line

anitamelbye — Thu, 18 Mar 2010 09:55:38 GMT

No suggestions?

I would like to have maxvalue highlighted in red, what can I do?

Anita