topic Re: Rank Accumuleted values troughout the day in QlikView https://community.qlik.com/t5/QlikView/Rank-Accumuleted-values-troughout-the-day/m-p/670510#M1071758 <HTML><HEAD></HEAD><BODY><P>hi,</P><P>To change the color u can give background color expression like this</P><P></P><P>=if( [Full Accumulation] = Max([Full Accumulation]) or [Full Accumulation] = Max([Full Accumulation]),Blue()) </P><P></P><P>Hope this helps. Vivek</P></BODY></HTML> Thu, 28 Aug 2014 12:10:14 GMT 2014-08-28T12:10:14Z Rank Accumuleted values troughout the day https://community.qlik.com/t5/QlikView/Rank-Accumuleted-values-troughout-the-day/m-p/670508#M1071755 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>now I've managed to rank single net values troughout the day.</P><P>However, anyone know a way to rank the ackumulated balances?</P><P>For instance, in the below example I wish to present the MAX/MIN accumulated as marked in blue.</P><P></P><P>Tnanks in advance,</P><P>Olle</P><P></P><P></P><P></P><P><BR /><IMG alt="Capture.JPG.jpg" class="jive-image" src="https://community.qlik.com/legacyfs/online/65484_Capture.JPG.jpg" /></P></BODY></HTML> Thu, 28 Aug 2014 11:59:14 GMT https://community.qlik.com/t5/QlikView/Rank-Accumuleted-values-troughout-the-day/m-p/670508#M1071755 2014-08-28T11:59:14Z Re: Rank Accumuleted values troughout the day https://community.qlik.com/t5/QlikView/Rank-Accumuleted-values-troughout-the-day/m-p/670509#M1071757 <HTML><HEAD></HEAD><BODY><P>Sample file attached.</P><P>//O </P></BODY></HTML> Thu, 28 Aug 2014 11:59:52 GMT https://community.qlik.com/t5/QlikView/Rank-Accumuleted-values-troughout-the-day/m-p/670509#M1071757 2014-08-28T11:59:52Z Re: Rank Accumuleted values troughout the day https://community.qlik.com/t5/QlikView/Rank-Accumuleted-values-troughout-the-day/m-p/670510#M1071758 <HTML><HEAD></HEAD><BODY><P>hi,</P><P>To change the color u can give background color expression like this</P><P></P><P>=if( [Full Accumulation] = Max([Full Accumulation]) or [Full Accumulation] = Max([Full Accumulation]),Blue()) </P><P></P><P>Hope this helps. Vivek</P></BODY></HTML> Thu, 28 Aug 2014 12:10:14 GMT https://community.qlik.com/t5/QlikView/Rank-Accumuleted-values-troughout-the-day/m-p/670510#M1071758 2014-08-28T12:10:14Z Re: Rank Accumuleted values troughout the day https://community.qlik.com/t5/QlikView/Rank-Accumuleted-values-troughout-the-day/m-p/670511#M1071759 <HTML><HEAD></HEAD><BODY><P>Hi Vivek,</P><P></P><P>sorry, maybe my description was a bit unclear.</P><P>I need a separate table box to pick up the min/max <STRONG style="text-decoration: underline;">accumulated</STRONG> values.</P><P>No need for color change</P><P></P><P>Regards,</P><P>Olle </P></BODY></HTML> Thu, 28 Aug 2014 12:22:12 GMT https://community.qlik.com/t5/QlikView/Rank-Accumuleted-values-troughout-the-day/m-p/670511#M1071759 2014-08-28T12:22:12Z Re: Re: Rank Accumuleted values troughout the day https://community.qlik.com/t5/QlikView/Rank-Accumuleted-values-troughout-the-day/m-p/670512#M1071760 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>See attached - I think this is what you are after.</P><P></P><P>HTH</P><P>Jonathan</P></BODY></HTML> Thu, 28 Aug 2014 12:41:57 GMT https://community.qlik.com/t5/QlikView/Rank-Accumuleted-values-troughout-the-day/m-p/670512#M1071760 jonathandienst 2014-08-28T12:41:57Z Re: Re: Rank Accumuleted values troughout the day https://community.qlik.com/t5/QlikView/Rank-Accumuleted-values-troughout-the-day/m-p/670513#M1071762 <HTML><HEAD></HEAD><BODY><P>Genius!</P><P>Thanks Jonathan!</P></BODY></HTML> Thu, 28 Aug 2014 12:57:35 GMT https://community.qlik.com/t5/QlikView/Rank-Accumuleted-values-troughout-the-day/m-p/670513#M1071762 2014-08-28T12:57:35Z