Sort expression in straight table

Anonymous — Thu, 27 Sep 2018 20:58:46 GMT

Hello everyone,

I have a straight table with several dimensions, and 3 expressions.

I want the straight table be sorted according to one of the expressions, in descending order.

However, my expression is not sortable in the sort tab in properties because expression is not checkable.

I have found that the tips is to sort the dimension with the expression.

However, when I do this, nothing changes in my straight table...

Here is the expression I want to sort the straight table with :

=num(Sum({$<HISTO_CTRL_TYPE_ELEM={'CRA'}, CTRL_SEMANTIQUE-={'VALORISATION/REJET/CHARGEMENT'}>}HISTO_CTRL_NB_ELEM_DIFF), '# ###,', ',', ' ')

& ' ('

& round(100 - (Sum({$<HISTO_CTRL_TYPE_ELEM={'CRA'}, CTRL_SEMANTIQUE-={'VALORISATION/REJET/CHARGEMENT'}>}HISTO_CTRL_NB_ELEM_DEST) * 100)

(Sum({$<HISTO_CTRL_TYPE_ELEM={'CRA'}, CTRL_SEMANTIQUE-={'VALORISATION/REJET/CHARGEMENT'}>}HISTO_CTRL_NB_ELEM_SRC)), 0.001)

& '%)'

Thank you for your help

topic Sort expression in straight table in QlikView