topic Double sorting in QlikView

Double sorting

Sun, 13 Dec 2009 19:38:12 GMT

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 ?

Double sorting

Sun, 13 Dec 2009 19:41:13 GMT

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

Double sorting

Sun, 13 Dec 2009 20:10:09 GMT

Please see if you can attach now.

Regards

Dewald

Double sorting

prieper — Mon, 14 Dec 2009 04:30:40 GMT

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

Double sorting

Mon, 14 Dec 2009 14:30:51 GMT

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....

Double sorting

johnw — Tue, 15 Dec 2009 08:03:05 GMT

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.