Sort in Graph

Mon, 26 Jan 2026 18:19:17 GMT

Hi All,

I want to put interactive sort on my Chart.

And color those arrows for chart sort.

this sort should work ascending and descending as well.

Re: Sort in Graph

Clever_Anjos — Thu, 12 Jun 2014 15:43:34 GMT

Please check if fits your needs.

You can improve layout later

Thu, 12 Jun 2014 15:46:34 GMT

Actually I am using Personal Edition.

Clever_Anjos — Thu, 12 Jun 2014 15:59:26 GMT

What I´ve done

1) Created one variable vSort

2) Created one textbox, configurated as image and with this expression:

=if(vSort=1,'qmem://<bundled>/BuiltIn/arrow_n_r.png',

if(vSort=2,'qmem://<bundled>/BuiltIn/arrow_s_r.png',

'qmem://<bundled>/BuiltIn/arrow_e.png'))

3) Attached one action "Set Variable" with expression =if(vSort=1,2,1)

4) Created one textbox, configurated as image and with this expression:

=if(vSort=3,'qmem://<bundled>/BuiltIn/arrow_n_r.png',

if(vSort=4,'qmem://<bundled>/BuiltIn/arrow_s_r.png',

'qmem://<bundled>/BuiltIn/arrow_e.png'))

5) Attached one action "Set Variable" with expression =if(vSort=3,4,3)

6) Created one textbox, configurated as image and with this expression:

=if(vSort=5,'qmem://<bundled>/BuiltIn/arrow_n_r.png',

if(vSort=6,'qmem://<bundled>/BuiltIn/arrow_s_r.png',

'qmem://<bundled>/BuiltIn/arrow_e.png'))

7) Attached one action "Set Variable" with expression =if(vSort=5,6,5)

😎 Used this expression as Sort Order of my table

Pick(vSort,

-sum(Expression1),

sum(Expression1),

-sum(Expression2),

sum(Expression2),

-sum(Expression3),

sum(Expression3)

)