topic Re: sort by expression retrieved from input field in QlikView

sort by expression retrieved from input field

pepe2209 — Tue, 19 Aug 2014 10:09:05 GMT

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

Re: sort by expression retrieved from input field

sujeetsingh — Tue, 19 Aug 2014 10:20:27 GMT

You need to define the Variable in another way.

Re: sort by expression retrieved from input field

northerner — Tue, 19 Aug 2014 10:22:47 GMT

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

Re: sort by expression retrieved from input field

pepe2209 — Tue, 19 Aug 2014 11:14:30 GMT

Yes this works for me,

Thanks!