topic Re: Highlighting the Top Value in a Graph in QlikView https://community.qlik.com/t5/QlikView/Highlighting-the-Top-Value-in-a-Graph/m-p/254707#M583373 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>See the attached sample file</P><P></P><P>And let me know</P><P></P><P>HTH</P><P></P><P>Regards</P><P>Anand</P></BODY></HTML> Mon, 12 Sep 2011 14:59:04 GMT its_anandrjs 2011-09-12T14:59:04Z Highlighting the Top Value in a Graph https://community.qlik.com/t5/QlikView/Highlighting-the-Top-Value-in-a-Graph/m-p/254705#M583371 <HTML><HEAD></HEAD><BODY><P>Hi everyone,</P><P></P><P>I hope you can help me.</P><P></P><P>I try to make color of the top value of a bar graph a red color and the rest of them a greyish one. How can I do this? Is there a way to use some kind of a rank formula, like e.g. rank1 = red, for all others usw grey?</P><P></P><P>The problem is that with every selection you make, the top value changes. And so does the datafield do.</P><P></P><P>Best wishes</P><P>Daniel</P></BODY></HTML> Mon, 12 Sep 2011 14:37:36 GMT https://community.qlik.com/t5/QlikView/Highlighting-the-Top-Value-in-a-Graph/m-p/254705#M583371 2011-09-12T14:37:36Z Highlighting the Top Value in a Graph https://community.qlik.com/t5/QlikView/Highlighting-the-Top-Value-in-a-Graph/m-p/254706#M583372 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Write some thing like this in the background option for colors</P><P></P><P>=if ( ( sum(Val) = Max( Total Val ) ) , red( ) , green( ) )</P><P></P><P>HTH</P><P></P><P>Regards</P><P>Anand</P></BODY></HTML> Mon, 12 Sep 2011 14:54:19 GMT https://community.qlik.com/t5/QlikView/Highlighting-the-Top-Value-in-a-Graph/m-p/254706#M583372 its_anandrjs 2011-09-12T14:54:19Z Re: Highlighting the Top Value in a Graph https://community.qlik.com/t5/QlikView/Highlighting-the-Top-Value-in-a-Graph/m-p/254707#M583373 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>See the attached sample file</P><P></P><P>And let me know</P><P></P><P>HTH</P><P></P><P>Regards</P><P>Anand</P></BODY></HTML> Mon, 12 Sep 2011 14:59:04 GMT https://community.qlik.com/t5/QlikView/Highlighting-the-Top-Value-in-a-Graph/m-p/254707#M583373 its_anandrjs 2011-09-12T14:59:04Z Re: Highlighting the Top Value in a Graph https://community.qlik.com/t5/QlikView/Highlighting-the-Top-Value-in-a-Graph/m-p/254708#M583374 <HTML><HEAD></HEAD><BODY><P>Thank you really much! That is what I was looking for <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P></BODY></HTML> Mon, 12 Sep 2011 15:01:51 GMT https://community.qlik.com/t5/QlikView/Highlighting-the-Top-Value-in-a-Graph/m-p/254708#M583374 2011-09-12T15:01:51Z Re: Highlighting the Top Value in a Graph https://community.qlik.com/t5/QlikView/Highlighting-the-Top-Value-in-a-Graph/m-p/254709#M583375 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Thanks i am glad to help you and it works for you.</P><P></P><P>Regards</P><P>Anand</P></BODY></HTML> Mon, 12 Sep 2011 15:03:53 GMT https://community.qlik.com/t5/QlikView/Highlighting-the-Top-Value-in-a-Graph/m-p/254709#M583375 its_anandrjs 2011-09-12T15:03:53Z