topic Sheet Sort Expression in QlikView

Sheet Sort Expression

Wed, 15 Sep 2010 14:12:00 GMT

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.

Sheet Sort Expression

Anonymous — Wed, 15 Sep 2010 20:08:16 GMT

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.

Sheet Sort Expression

johnw — Wed, 15 Sep 2010 20:12:00 GMT

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)

Sheet Sort Expression

Thu, 16 Sep 2010 11:21:04 GMT

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.