topic Sorting a straight table based on expression via a button in QlikView

Sorting a straight table based on expression via a button

Fri, 24 Apr 2015 13:57:31 GMT

I have a simple straight table with a 'name' dimension and then a calculated numeric value currently sorted by the expression in numeric order ascending. I need to be able to allow users to sort in ascending/ descending order via a button in the same way as double clicking on the row header controls the interactive sort on a straight table but needs to be via variable/button. I can only sort the dimension via an expression so not sure if this is possible.

Any ideas? Thanks

Re: Sorting a straight table based on expression via a button

Anonymous — Fri, 24 Apr 2015 14:01:09 GMT

You can use a conditional expression, where the condition is defined by a variable, and the variable is defined by a button.

But - what's wrong with dbl-clicking???

Re: Sorting a straight table based on expression via a button

anguila — Fri, 24 Apr 2015 14:11:56 GMT

You can use a variable to change the sort order, using the sort by expression in the straight table:

Order by click:

I attach you an example.

Regards,

Re: Sorting a straight table based on expression via a button

Fri, 24 Apr 2015 15:02:19 GMT

Thanks David..Just the job!! I'd nearly done that myself but hadn't altered the sort priority. Users don't want column headings on table so cant double click

Thanks

Gavin

Re: Sorting a straight table based on expression via a button

vikasmahajan — Wed, 15 Jun 2016 07:44:00 GMT

good one

Vikas