topic Re: Allow User to Sort data on a table in QlikView

Allow User to Sort data on a table

Thu, 06 Dec 2012 12:13:04 GMT

Hi,

Is it possible to allow a user to sort data on a table? eg allow them to sort results from high to low, low to high. Or must this be pre-defined in the backend and never changed?

I know it is possible to use a sort expression but I'm not sure what I would need to put in there. I'm thinking of having a variable that the user can control which will the sort expression will base off of. e.g. user clicks a button which sets vSortOrder to 1. The sort expression will sort according to the value of this variable.

Any ideas?

Cheers,

Re: Allow User to Sort data on a table

Gysbert_Wassenaar — Thu, 06 Dec 2012 12:20:41 GMT

In table boxes all columns are sortable. You can define how columns should be sorted, but users can change the sort order interactively. For straight tables you have an option per column to allow interactive sort. The default is to allow it. Pivot tables are very finicky when it comes to sorting and it doesn't have interactive sort.

Re: Allow User to Sort data on a table

Thu, 06 Dec 2012 12:52:45 GMT

Hi Gysbert,

Thanks for the reply. Without using the default sort "Y-value: descending" is there an expression that would do this? Sorting from high to low regardless of number of entries. Data is all in percentages.

Cheers,