Sheet Sort Expression

[#1]

I am using a command button and a sheet object. While clicking on button, one variable is set by a value as either "ASC" or "DESC". The value set on the variable is needed to be applied in one of the columns in the sheet for sorting.

Kindly help me on this challenge.

[Anonymous]

Maybe I am not understanding your question. Why would you not use Expression & put in the variable name in Sort tab of the object?

Dinesh.

[johnw]

What's wrong with the default QlikView controls for sorting?

Anyway, I suspect you could do it with a sort expression, something like this:

=if(MyVariable='ASC',MyColumn,-MyColumn)

[#4]

Thanks. It works. I have one more question as follows.

I have assigned value to the variable while clicking on another button object as "ASC". But as per the value assigned in the variable the sort expression is not working.

Kindly suggest how can the chart object get the value assigned on the variable.

Thanks.