topic sort by color in QlikView https://community.qlik.com/t5/QlikView/sort-by-color/m-p/200578#M59051 <HTML><HEAD></HEAD><BODY><P>Actually you should order by the expression used to calculate the colors.</P></BODY></HTML> Wed, 24 Nov 2010 16:25:30 GMT fernandotoledo 2010-11-24T16:25:30Z sort by color https://community.qlik.com/t5/QlikView/sort-by-color/m-p/200577#M59050 <HTML><HEAD></HEAD><BODY><P>Hello</P><P>I would like to sort values in a straight table according to colour.</P><P>I have positive and negative values in red and also in green. I want red values first according to magnitute and the green values last according to magnitude.</P><P>How do I do this in qlikview.</P><P>K</P></BODY></HTML> Wed, 24 Nov 2010 15:28:14 GMT https://community.qlik.com/t5/QlikView/sort-by-color/m-p/200577#M59050 2010-11-24T15:28:14Z sort by color https://community.qlik.com/t5/QlikView/sort-by-color/m-p/200578#M59051 <HTML><HEAD></HEAD><BODY><P>Actually you should order by the expression used to calculate the colors.</P></BODY></HTML> Wed, 24 Nov 2010 16:25:30 GMT https://community.qlik.com/t5/QlikView/sort-by-color/m-p/200578#M59051 fernandotoledo 2010-11-24T16:25:30Z sort by color https://community.qlik.com/t5/QlikView/sort-by-color/m-p/200579#M59052 <HTML><HEAD></HEAD><BODY><P>Hey what about creating a num() function with the colour inside in rgb format?</P><P>Yo can create a number field with the colours and then order by them.</P><P>Example : =num(rgb(255,0,255)).</P><P>Hope it helps!!</P></BODY></HTML> Wed, 24 Nov 2010 16:26:41 GMT https://community.qlik.com/t5/QlikView/sort-by-color/m-p/200579#M59052 marcel_olmo 2010-11-24T16:26:41Z