topic Colour coding in QlikView https://community.qlik.com/t5/QlikView/Colour-coding/m-p/615850#M1103827 <HTML><HEAD></HEAD><BODY><P> Nearly there with this...</P><P></P><P></P><P>I'm trying to colour code some text boxes but the coding is not as i want it.</P><P></P><P>I want the highest stop value to turn bright red. The formulae currently shades the values out of the grand total NOT the total of the selections and therefore none of the stops actually turn bright red</P><P></P><P>If I selected just Market St, Shudehill and Piccadilly then I would want Market Street to turn bright red and the other two stops lighter shades with the unselected stops not formatted at all </P><P></P><P>If I selected all the stops then I simply need the highest stop value to turn bright red and the others shaded accordingly</P><P></P><P>See attached..................</P></BODY></HTML> Mon, 24 Mar 2014 17:37:18 GMT 2014-03-24T17:37:18Z Colour coding https://community.qlik.com/t5/QlikView/Colour-coding/m-p/615850#M1103827 <HTML><HEAD></HEAD><BODY><P> Nearly there with this...</P><P></P><P></P><P>I'm trying to colour code some text boxes but the coding is not as i want it.</P><P></P><P>I want the highest stop value to turn bright red. The formulae currently shades the values out of the grand total NOT the total of the selections and therefore none of the stops actually turn bright red</P><P></P><P>If I selected just Market St, Shudehill and Piccadilly then I would want Market Street to turn bright red and the other two stops lighter shades with the unselected stops not formatted at all </P><P></P><P>If I selected all the stops then I simply need the highest stop value to turn bright red and the others shaded accordingly</P><P></P><P>See attached..................</P></BODY></HTML> Mon, 24 Mar 2014 17:37:18 GMT https://community.qlik.com/t5/QlikView/Colour-coding/m-p/615850#M1103827 2014-03-24T17:37:18Z Re: Colour coding https://community.qlik.com/t5/QlikView/Colour-coding/m-p/615851#M1103831 <HTML><HEAD></HEAD><BODY><P>Hi. </P><P></P><P>ColorMix1(</P><P><STRONG>(Sum({$&lt;Stop={'SHU'}&gt;}Revenue))/</STRONG></P><P><STRONG>Max(Aggr(Sum(Revenue), Stop)),</STRONG></P><P>White(),</P><P>LightRed()</P><P>)</P></BODY></HTML> Mon, 24 Mar 2014 20:27:20 GMT https://community.qlik.com/t5/QlikView/Colour-coding/m-p/615851#M1103831 whiteline 2014-03-24T20:27:20Z