sort by color

[#1]

Hello

I would like to sort values in a straight table according to colour.

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.

How do I do this in qlikview.

K

[fernandotoledo]

Actually you should order by the expression used to calculate the colors.

[marcel_olmo]

Hey what about creating a num() function with the colour inside in rgb format?

Yo can create a number field with the colours and then order by them.

Example : =num(rgb(255,0,255)).

Hope it helps!!