Sort in Graph

[#1]

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.

[Clever_Anjos]

Please check if fits your needs.

You can improve layout later

[#3]

Actually I am using Personal Edition.

[Clever_Anjos · Accepted solution]

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)

)