sort by expression retrieved from input field

[pepe2209]

Hello.

I would like to achieve the following:

I've several buttons which adjust the expression in inputfield "vSort"

for example,

Button 1: change variable vSort, value: =only({1} Present)

Button 2: change variable vSort, value: etc.

Now i want to sort a table by expression, using as expression =vSort, but this does not work because vSort is already a calculated value of the expression: =only({1} Present) and not the expression itself.

So i would like to change the sorting easily by clicking the buttons (which can have some extensive expressions).

is this possible?

your help would be much appreciated,

regards

Peter

[sujeetsingh]

You need to define the Variable in another way.

[northerner · Accepted solution]

Hi Peter,

Try this:

1) When you define the variable value in the button, don't use the'=' sign - i.e. instead of "=only({1} Present)" use "only({1} Present)"

2) Depending what is in the chart sort expression, you may then need to use a dollar expansion, i.e. =$(vSort)

Step 1 should store the expression text in the variable, rather than the expression result.  Step 2 will then give you the result of the expression (if required).

Hope this helps

[pepe2209]

Yes this works for me,

Thanks!