Double sorting

[#1]

Hello guys,

I Wonder if you have coped with this issue.

Well the users want to do a Double sorting on a table ---->i.e. (see attach file) first they

want to sort by "state" (and to see that usa is first and then comes usb) after that they want to

sort by ID inside the already sorted table, you can call it sorting by two keys .

(in excel its so easy to perform...)

How can I do that ?

[#2]

It seems that there is some problem with the server that avoiding me to attach the file.....

[#3]

Hi

Please see if you can attach now.

Regards

Dewald

[prieper]

In QV you need to sort by concatenation of the keys, meaning that - unless you show this field - it will be not qlickable in tables.

Peter

[#5]

Peter, thanks BUT

unforunately the users want to sort by diffrent fields each time, meaning that today the want to sort by column A and to make another sort

on column C, BUT maybe tomorrow they want to sort by column D and then by column E....So I can built "keys" from two fields

because I don't know how they will want to sort the data....

[johnw]

You need to specify a sort order for ID, which is currently missing. Go to the sort tab, select ID, and put a checkmark in, say, Numeric Value. Make sure you have a checkmark in Allow Interactive Sort. Double click on the ID column to sort by ID, then double click on the state column to sort by state. You should now have the data sorted by state, and within each state sorted by ID. The user can do this as many times as they want with as many columns as they want, and it's a very common way of handling sorting by multiple columns.