topic Re: Sorting a straight table based on an hidden column/ background color in App Development

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

Qlik_Stek — Sun, 03 Nov 2024 16:11:16 GMT

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!

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

Qrishna — Mon, 04 Nov 2024 11:03:50 GMT

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'.

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

Qlik_Stek — Mon, 04 Nov 2024 11:10:02 GMT

Hey, the column is hidden.

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

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

Qrishna — Mon, 04 Nov 2024 11:41:09 GMT

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

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

Qlik_Stek — Mon, 04 Nov 2024 12:23:07 GMT

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).