Sorting a straight table based on an hidden column/ background color

[Qlik_Stek]

Hi!

I have a straight table with a few columns in it, some of them are dimensions, and some of them are measures.

In the table I have a column that represents the value of a variable (numeric), but the field in it is using a Abs function to show all the values in a greater than 0 value.

The background color of the rows in the table is based on that value I've mentioned.

If the value in it suppose to be a negative - the row color will be RED.

If the value in it suppose to be a positive - the row color will be GREEN.

(And if the value = 0, then the color will be BLACK).

My question is - how can I sort the table, so the GREEN ROWS will show up first (and in DESCENDING order),

Then the RED ROWS (also in DESCENDING order),

and then the BLACK ROWS (also in DESCENDING order).

one way I've tried is to create a column that represents each color for each row, and then sort the table according to it, but I would like to do it with this column hidden.

Any help or suggestion will be great.

Thanks!

[Qrishna]

 your measure is hidden?

if not:

Goto Sorting, Turn off 'Auto' , pull the 'your Measure'  up on top of all the other columns, Check the box 'Sort Numerically' and select 'Descending'.

[Qlik_Stek]

Hey, the column is hidden.

Got any suggestions for how to sort based on that hidden column?

[Qrishna]

Yes you could sort with the expression thats hidden.check 'Sort by expression' and wirte you expression/field

[Qlik_Stek]

My bad, the hidden column is actually a measure.

The problem is I can sort by expression only on columns which are dimensions

(All my dimensions are already using this option).