topic Re: sort order change on straight table based on button selction in QlikView

sort order change on straight table based on button selction

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi team,

my requirement is to change the column sort order of the straight table based on button selection

example: i have straight table with 5 columns emp name,manager name, date, grade and salary and on the top I have a box with 3 buttons. Now I need to present the table with sort orders on different columns based on the button selection.

Is there any way we can achieve this using one single straight table

Thanks,

Pani

Re: sort order change on straight table based on button selction

Anonymous — Thu, 15 Mar 2018 10:26:18 GMT

Hi Pani

There is no way to achieve this functionality using one single straight table. Its possible with multiple tables.

Thanks

Re: sort order change on straight table based on button selction

YoussefBelloum — Thu, 15 Mar 2018 10:42:56 GMT

Hi,

which type of sorting you want ?

alphabetical sorting for the dimensions and ascending./ descending sorting for measures ?

or only sorting for measures ?3

and you have only one Measure (salary) ? or Grade is also a measure ?

Try to attach sample data, there is way to do this

Re: sort order change on straight table based on button selction

Anonymous — Thu, 15 Mar 2018 10:52:03 GMT

Thanks for the reply

As I mentioned earlier I will have 3 buttons.

If I click on first button, table should sort based on emp name field in ascending order.

If I click on second button, table should sort based on date field in descending order.

If I click on third button, it should based on measure say for suppose which ever manager has more reportees, he should come on top and which ever manager has least reportees he should in the last. So descending based on count of reportees.

Re: sort order change on straight table based on button selction

YoussefBelloum — Thu, 15 Mar 2018 10:53:48 GMT

ok, would you be able to attach sample data (some rows) to make the tests ?

Re: sort order change on straight table based on button selction

Anonymous — Thu, 15 Mar 2018 11:30:03 GMT

I am unable to attach file

Re: sort order change on straight table based on button selction

YoussefBelloum — Thu, 15 Mar 2018 12:39:59 GMT

You don't know how to attach or you cant because it is confidential ??

If it is confidential, create some (sample) rows on an excel file and attach it Or create an inline load here